Product: | WSM - Shop Floor Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSM_SM_RESULTING_JOBS_V |
SELECT SM.ROWID
, SM.TRANSACTION_ID
, SM.WIP_ENTITY_NAME
, SM.WIP_ENTITY_ID
, SM.DESCRIPTION
, SM_HD.ORGANIZATION_ID
, SM.PRIMARY_ITEM_ID
, SM.CLASS_CODE
, SM.START_QUANTITY
, DECODE(SM.JOB_TYPE
, 1
, 'STANDARD'
, 3
, 'NON-STANDARD'
, 'STANDARD')
, SM.BOM_REFERENCE_ID
, SM.ROUTING_REFERENCE_ID
, SM.COMMON_BOM_SEQUENCE_ID
, SM.COMMON_ROUTING_SEQUENCE_ID
, SM.BOM_REVISION
, SM.ROUTING_REVISION
, SM.BOM_REVISION_DATE
, SM.ROUTING_REVISION_DATE
, SM.ALTERNATE_BOM_DESIGNATOR
, SM.ALTERNATE_ROUTING_DESIGNATOR
, SM.COMPLETION_SUBINVENTORY
, SM.COMPLETION_LOCATOR_ID
, SM.STARTING_OPERATION_SEQ_NUM
, SM.STARTING_OPERATION_CODE
, SM.STARTING_INTRAOPERATION_STEP
, SM.STARTING_STD_OP_ID
, MFG.MEANING
, BOS.OPERATION_DESCRIPTION
, BD.DEPARTMENT_CODE
, BD.DEPARTMENT_ID
, SM.SCHEDULED_START_DATE
, SM.SCHEDULED_COMPLETION_DATE
, SM.DEMAND_CLASS
, SM.BONUS_ACCT_ID
, SM.FORWARD_OP_OPTION
, SM.LAST_UPDATE_DATE
, SM.LAST_UPDATED_BY
, SM.CREATION_DATE
, SM.CREATED_BY
, SM.LAST_UPDATE_LOGIN
, SM.ATTRIBUTE_CATEGORY
, SM.ATTRIBUTE1
, SM.ATTRIBUTE2
, SM.ATTRIBUTE3
, SM.ATTRIBUTE4
, SM.ATTRIBUTE5
, SM.ATTRIBUTE6
, SM.ATTRIBUTE7
, SM.ATTRIBUTE8
, SM.ATTRIBUTE9
, SM.ATTRIBUTE10
, SM.ATTRIBUTE11
, SM.ATTRIBUTE12
, SM.ATTRIBUTE13
, SM.ATTRIBUTE14
, SM.ATTRIBUTE15
, SM.REQUEST_ID
, SM.PROGRAM_APPLICATION_ID
, SM.PROGRAM_ID
, SM.PROGRAM_UPDATE_DATE
, SM.NET_QUANTITY
, SM.COPRODUCTS_SUPPLY
, SM.SPLIT_HAS_UPDATE_ASSY
FROM MFG_LOOKUPS MFG
, WSM_SPLIT_MERGE_TRANSACTIONS SM_HD
, WSM_SM_RESULTING_JOBS SM
, BOM_OPERATION_SEQUENCES BOS
, BOM_DEPARTMENTS BD
WHERE SM.TRANSACTION_ID = SM_HD.TRANSACTION_ID
AND NVL(SM.COMMON_ROUTING_SEQUENCE_ID
, -9999) = BOS.ROUTING_SEQUENCE_ID
AND NVL(SM.STARTING_OPERATION_SEQ_NUM
, -9999) = BOS.OPERATION_SEQ_NUM (+)
AND NVL(BOS.OPERATION_TYPE
, 1) = 1
AND (SM.ROUTING_REVISION_DATE BETWEEN NVL(BOS.EFFECTIVITY_DATE
, SM.ROUTING_REVISION_DATE)
AND NVL(BOS.DISABLE_DATE
, SM.ROUTING_REVISION_DATE+1) )
AND MFG.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND MFG.LOOKUP_CODE = SM.STARTING_INTRAOPERATION_STEP
AND BOS.DEPARTMENT_ID = BD.DEPARTMENT_ID