VIEW: APPS.MSC_WIP_JOB_RESOURCES_V

Source

View Text - Preformatted

SELECT mjd.parent_header_id, mjd.organization_id, substr(mtp.ORGANIZATION_CODE, instr(mtp.ORGANIZATION_CODE,':')+1) ORGANIZATION_CODE, mjd.operation_seq_num, mjd.operation_seq_id, decode(mjd.operation_seq_id, NULL, NULL,nvl(MSC_ST_UTIL.RET_CODE ( 'OPERATION_SEQUENCE_ID', mjd.operation_seq_id),mjd.operation_seq_num)) OPERATION_SEQ_CODE, mjd.RESOURCE_SEQ_NUM, decode(mjd.RESOURCE_SEQ_NUM, NULL, NULL, nvl(MSC_ST_UTIL.RET_CODE ('RESOURCE_SEQ_NUM', mjd.RESOURCE_SEQ_NUM), mjd.RESOURCE_SEQ_NUM)) RESOURCE_SEQ_CODE, mjd.RESOURCE_ID_NEW, decode(mjd.RESOURCE_ID_NEW, NULL, NULL, nvl(MSC_ST_UTIL.RET_CODE ('RESOURCE_ID', mjd.RESOURCE_ID_NEW),mjd.RESOURCE_ID_NEW)) RESOURCE_CODE_NEW, mjd.RESOURCE_ID_OLD, decode(mjd.RESOURCE_ID_OLD, NULL, NULL, nvl(MSC_ST_UTIL.RET_CODE ('RESOURCE_ID', mjd.RESOURCE_ID_OLD ),mjd.RESOURCE_ID_OLD)) RESOURCE_CODE_OLD, mjd.USAGE_RATE_OR_AMOUNT, mjd.ASSIGNED_UNITS, mjd.UOM_CODE, mjd.START_DATE, mjd.COMPLETION_DATE, mjd.DEPARTMENT_ID, decode(mjd.DEPARTMENT_ID, NULL, NULL, nvl(MSC_ST_UTIL.RET_CODE ( 'DEPARTMENT_ID', mjd.DEPARTMENT_ID),mjd.DEPARTMENT_ID)) DEPARTMENT_CODE, mjd.ALTERNATE_NUM, mjd.SR_INSTANCE_ID, mai.INSTANCE_CODE FROM MSC_WIP_JOB_DTLS_INTERFACE mjd, MSC_TRADING_PARTNERS mtp, MSC_APPS_INSTANCES mai WHERE mjd.organization_id = mtp.sr_tp_id and mtp.partner_type = 3 and mtp.sr_instance_id = mjd.sr_instance_id and mjd.load_type = 1 and mjd.sr_instance_id = mai.instance_id

View Text - HTML Formatted

SELECT MJD.PARENT_HEADER_ID
, MJD.ORGANIZATION_ID
, SUBSTR(MTP.ORGANIZATION_CODE
, INSTR(MTP.ORGANIZATION_CODE
, ':')+1) ORGANIZATION_CODE
, MJD.OPERATION_SEQ_NUM
, MJD.OPERATION_SEQ_ID
, DECODE(MJD.OPERATION_SEQ_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ( 'OPERATION_SEQUENCE_ID'
, MJD.OPERATION_SEQ_ID)
, MJD.OPERATION_SEQ_NUM)) OPERATION_SEQ_CODE
, MJD.RESOURCE_SEQ_NUM
, DECODE(MJD.RESOURCE_SEQ_NUM
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('RESOURCE_SEQ_NUM'
, MJD.RESOURCE_SEQ_NUM)
, MJD.RESOURCE_SEQ_NUM)) RESOURCE_SEQ_CODE
, MJD.RESOURCE_ID_NEW
, DECODE(MJD.RESOURCE_ID_NEW
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('RESOURCE_ID'
, MJD.RESOURCE_ID_NEW)
, MJD.RESOURCE_ID_NEW)) RESOURCE_CODE_NEW
, MJD.RESOURCE_ID_OLD
, DECODE(MJD.RESOURCE_ID_OLD
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('RESOURCE_ID'
, MJD.RESOURCE_ID_OLD )
, MJD.RESOURCE_ID_OLD)) RESOURCE_CODE_OLD
, MJD.USAGE_RATE_OR_AMOUNT
, MJD.ASSIGNED_UNITS
, MJD.UOM_CODE
, MJD.START_DATE
, MJD.COMPLETION_DATE
, MJD.DEPARTMENT_ID
, DECODE(MJD.DEPARTMENT_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ( 'DEPARTMENT_ID'
, MJD.DEPARTMENT_ID)
, MJD.DEPARTMENT_ID)) DEPARTMENT_CODE
, MJD.ALTERNATE_NUM
, MJD.SR_INSTANCE_ID
, MAI.INSTANCE_CODE
FROM MSC_WIP_JOB_DTLS_INTERFACE MJD
, MSC_TRADING_PARTNERS MTP
, MSC_APPS_INSTANCES MAI
WHERE MJD.ORGANIZATION_ID = MTP.SR_TP_ID
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_INSTANCE_ID = MJD.SR_INSTANCE_ID
AND MJD.LOAD_TYPE = 1
AND MJD.SR_INSTANCE_ID = MAI.INSTANCE_ID