CREATE TABLE irc_tnetwork_agency_req_info (
    REQ_INFO_ID                 NUMBER(18, 0) ,
    REQUISITION_ID              NUMBER(18, 0)     NOT NULL,
    AGENCY_ACCEPTANCE_STATUS    VARCHAR2(120) ,
    REDIRECT_URL                VARCHAR2(4000),
    COMMENTS                    VARCHAR2(4000),
    TN_AGENCY_ID                NUMBER(18, 0)     NOT NULL,
    TN_AGENCY_NAME              VARCHAR2(960)     NOT NULL,
    TN_AGENT_ID                 NUMBER(18, 0)     NOT NULL,
    TN_AGENT_NAME               VARCHAR2(960)     NOT NULL,
    OBJECT_STATUS               VARCHAR2(120)     NOT NULL,
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)      NOT NULL,
    CREATION_DATE               TIMESTAMP(6)      NOT NULL,
    CREATED_BY                  VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY             VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128) ,
    REQ_INFO_ID                 NUMBER(18, 0) ,
    REQUISITION_ID              NUMBER(18, 0)     NOT NULL,
    AGENCY_ACCEPTANCE_STATUS    VARCHAR2(120) ,
    REDIRECT_URL                VARCHAR2(4000),
    COMMENTS                    VARCHAR2(4000),
    TN_AGENCY_ID                NUMBER(18, 0)     NOT NULL,
    TN_AGENCY_NAME              VARCHAR2(960)     NOT NULL,
    TN_AGENT_ID                 NUMBER(18, 0)     NOT NULL,
    TN_AGENT_NAME               VARCHAR2(960)     NOT NULL,
    OBJECT_STATUS               VARCHAR2(120)     NOT NULL,
    OBJECT_VERSION_NUMBER       NUMBER(9, 0)      NOT NULL,
    CREATION_DATE               TIMESTAMP(6)      NOT NULL,
    CREATED_BY                  VARCHAR2(256)     NOT NULL,
    LAST_UPDATED_BY             VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE            TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN           VARCHAR2(128) ,
    CONSTRAINT pk_irc_tnetwork_agency_req_info PRIMARY KEY (REQ_INFO_ID, REQ_INFO_ID)
);
