Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | This view contains request to create or modify discrete jobs or repetitive schedules. This view is used in XML-outbound |
Implementation/DBA Data: | APPS.MSC_WIP_JOB_SCHEDULE_V |
SELECT MJS.SOURCE_LINE_ID
, MJS.ORGANIZATION_ID
, MTP.PARTNER_NAME
, SUBSTR(MTP.ORGANIZATION_CODE
, INSTR(MTP.ORGANIZATION_CODE
, ':')+1) ORGANIZATION_CODE
, MJS.STATUS_TYPE
, LOOKUP1.MEANING STATUS
, MJS.LAST_UNIT_COMPLETION_DATE
, MJS.LINE_ID
, DECODE(MJS.LINE_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('LINE_ID'
, MJS.LINE_ID)
, MJS.LINE_ID)) LINE_CODE
, MJS.PRIMARY_ITEM_ID
, DECODE(MJS.PRIMARY_ITEM_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('SR_INVENTORY_ITEM_ID'
, MJS.PRIMARY_ITEM_ID)
, MJS.PRIMARY_ITEM_ID)) PRIMARY_ITEM_NAME
, MJS.CLASS_CODE
, NVL(MJS.JOB_NAME
, MSC_ST_UTIL.RET_CODE('WIP_ENTITY_ID'
, MJS.WIP_ENTITY_ID)) JOB_NAME
, MJS.ALTERNATE_ROUTING_DESIGNATOR
, MJS.ALTERNATE_BOM_DESIGNATOR
, MJS.START_QUANTITY
, MJS.BUILD_SEQUENCE
, MJS.PROJECT_ID
, DECODE(MJS.PROJECT_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('PROJECT_ID'
, MJS.PROJECT_ID)
, MJS.PROJECT_ID)) PROJECT_NUMBER
, MJS.TASK_ID
, DECODE(MJS.TASK_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('TASK_ID'
, MJS.TASK_ID)
, MJS.TASK_ID)) TASK_NUMBER
, MJS.NET_QUANTITY
, MJS.UOM_CODE
, MJS.SR_INSTANCE_ID
, MAI.INSTANCE_CODE
, MJS.BILL_RTG_EXPLOSION_FLAG
, MJS.FIRST_UNIT_START_DATE
, MJS.BOM_REFERENCE_ID
, DECODE(MJS.BOM_REFERENCE_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('BILL_SEQUENCE_ID'
, MJS.BOM_REFERENCE_ID)
, MJS.BOM_REFERENCE_ID)) BOM_NAME
, MJS.ROUTING_REFERENCE_ID
, DECODE(MJS.ROUTING_REFERENCE_ID
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('ROUTING_SEQUENCE_ID'
, MJS.ROUTING_REFERENCE_ID)
, MJS.ROUTING_REFERENCE_ID)) ROUTING_NAME
, DECODE(MJS.CFM_ROUTING_FLAG
, 3
, 'YES'
, 'NO') COPRODUCTS_SUPPLY
FROM MSC_WIP_JOB_SCHEDULE_INTERFACE MJS
, MSC_TRADING_PARTNERS MTP
, MFG_LOOKUPS LOOKUP1
, MSC_APPS_INSTANCES MAI
WHERE MJS.ORGANIZATION_ID = MTP.SR_TP_ID
AND MTP.PARTNER_TYPE = 3
AND MTP.SR_INSTANCE_ID = MJS.SR_INSTANCE_ID
AND MJS.SR_INSTANCE_ID = MAI.INSTANCE_ID
AND LOOKUP1.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND MJS.STATUS_TYPE = LOOKUP1.LOOKUP_CODE