CREATE TABLE irc_tn_job_work_locs_b (
    TN_JOB_WORK_LOC_ID       NUMBER(18, 0),
    TN_JOB_ID                NUMBER(18, 0)    NOT NULL,
    PRIMARY_FLAG             VARCHAR2(4)  ,
    FA_LOCATION_ID           NUMBER(18, 0)    NOT NULL,
    FA_LOCATION_CODE         VARCHAR2(240)    NOT NULL,
    ADDRESS_LINE_1           VARCHAR2(960),
    ADDRESS_LINE_2           VARCHAR2(960),
    ADDRESS_LINE_3           VARCHAR2(960),
    ADDRESS_LINE_4           VARCHAR2(960),
    BUILDING                 VARCHAR2(960),
    TOWN_OR_CITY             VARCHAR2(240),
    POSTAL_CODE              VARCHAR2(120),
    COUNTRY                  VARCHAR2(240),
    REGION_1                 VARCHAR2(480),
    REGION_2                 VARCHAR2(480),
    REGION_3                 VARCHAR2(480),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    TN_JOB_WORK_LOC_ID       NUMBER(18, 0),
    TN_JOB_ID                NUMBER(18, 0)    NOT NULL,
    PRIMARY_FLAG             VARCHAR2(4)  ,
    FA_LOCATION_ID           NUMBER(18, 0)    NOT NULL,
    FA_LOCATION_CODE         VARCHAR2(240)    NOT NULL,
    ADDRESS_LINE_1           VARCHAR2(960),
    ADDRESS_LINE_2           VARCHAR2(960),
    ADDRESS_LINE_3           VARCHAR2(960),
    ADDRESS_LINE_4           VARCHAR2(960),
    BUILDING                 VARCHAR2(960),
    TOWN_OR_CITY             VARCHAR2(240),
    POSTAL_CODE              VARCHAR2(120),
    COUNTRY                  VARCHAR2(240),
    REGION_1                 VARCHAR2(480),
    REGION_2                 VARCHAR2(480),
    REGION_3                 VARCHAR2(480),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    CONSTRAINT pk_irc_tn_job_work_locs_b PRIMARY KEY (TN_JOB_WORK_LOC_ID, TN_JOB_WORK_LOC_ID)
);
