Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | This view contains requests to add/delete/modify material for existing discrete jobs or repetitive schedules. This view is used in XML outbound |
Implementation/DBA Data: | APPS.MSC_WIP_JOB_COMPONENTS_V |
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.INVENTORY_ITEM_ID_NEW
, DECODE(MJD.INVENTORY_ITEM_ID_NEW
, NULL
, NULL
, NVL(MSC_ST_UTIL.RET_CODE ('SR_INVENTORY_ITEM_ID'
, MJD.INVENTORY_ITEM_ID_NEW)
, MJD.INVENTORY_ITEM_ID_NEW)) ITEM_NAME_NEW
, MJD.QUANTITY_PER_ASSEMBLY
, 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.WIP_SUPPLY_TYPE
, MJD.DATE_REQUIRED
, MJD.REQUIRED_QUANTITY
, MJD.QUANTITY_ISSUED
, MJD.UOM_CODE
, MJD.SUPPLY_SUBINVENTORY
, MJD.SUPPLY_LOCATOR_ID
, 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 = 2
AND MTP.SR_INSTANCE_ID =MJD.SR_INSTANCE_ID
AND MJD.SR_INSTANCE_ID = MAI.INSTANCE_ID
AND MJD.LOAD_TYPE = 2