Product: | WSM - Shop Floor Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSM_SM_STARTING_JOBS_V |
SELECT DISTINCT(WSSJ.ROWID)
, WSSJ.TRANSACTION_ID
, WSSJ.WIP_ENTITY_ID
, WSSJ.WIP_ENTITY_NAME
, WDJ.CLASS_CODE
, WDJ.KANBAN_CARD_ID
, WSSJ.DESCRIPTION
, WSSJ.REPRESENTATIVE_FLAG
, DECODE(WSSJ.PRIMARY_ITEM_ID
, NULL
, WDJ.PRIMARY_ITEM_ID
, WSSJ.PRIMARY_ITEM_ID) PRIMARY_ITEM_ID
, WSSJ.OPERATION_SEQ_NUM
, NVL(BSO.OPERATION_CODE
, '')
, NVL(WO.STANDARD_OPERATION_ID
, '')
, BOS.OPERATION_DESCRIPTION
, WSSJ.INTRAOPERATION_STEP
, BD.DEPARTMENT_CODE
, BD.DEPARTMENT_ID
, MFG.MEANING
, WSSJ.AVAILABLE_QUANTITY
, WSSJ.JOB_START_QUANTITY
, WO.QUANTITY_COMPLETED
, DECODE(WDJ.JOB_TYPE
, 1
, 'STANDARD'
, 3
, 'NON-STANDARD'
, 'STANDARD')
, WSSJ.SCHEDULED_START_DATE
, WSSJ.SCHEDULED_COMPLETION_DATE
, WSSJ.COMPLETION_SUBINVENTORY
, WSSJ.COMPLETION_LOCATOR_ID
, WSSJ.BOM_REFERENCE_ID
, WSSJ.BILL_SEQUENCE_ID
, WSSJ.BOM_REVISION
, WSSJ.BOM_REVISION_DATE
, BBOM.ALTERNATE_BOM_DESIGNATOR
, WSSJ.ROUTING_REFERENCE_ID
, WSSJ.ROUTING_SEQ_ID
, WSSJ.ROUTING_REVISION
, WSSJ.ROUTING_REVISION_DATE
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, WSSJ.LAST_UPDATE_DATE
, WSSJ.LAST_UPDATED_BY
, WSSJ.CREATION_DATE
, WSSJ.CREATED_BY
, WSSJ.LAST_UPDATE_LOGIN
, WSSJ.ATTRIBUTE_CATEGORY
, WSSJ.ATTRIBUTE1
, WSSJ.ATTRIBUTE2
, WSSJ.ATTRIBUTE3
, WSSJ.ATTRIBUTE4
, WSSJ.ATTRIBUTE5
, WSSJ.ATTRIBUTE6
, WSSJ.ATTRIBUTE7
, WSSJ.ATTRIBUTE8
, WSSJ.ATTRIBUTE9
, WSSJ.ATTRIBUTE10
, WSSJ.ATTRIBUTE11
, WSSJ.ATTRIBUTE12
, WSSJ.ATTRIBUTE13
, WSSJ.ATTRIBUTE14
, WSSJ.ATTRIBUTE15
, WSSJ.REQUEST_ID
, WSSJ.PROGRAM_APPLICATION_ID
, WSSJ.PROGRAM_ID
, WSSJ.PROGRAM_UPDATE_DATE
, WSSJ.COPRODUCTS_SUPPLY
, WSSJ.NET_QUANTITY
FROM WSM_SM_STARTING_JOBS WSSJ
, WIP_DISCRETE_JOBS WDJ
, WIP_OPERATIONS WO
, BOM_STANDARD_OPERATIONS BSO
, MFG_LOOKUPS MFG
, BOM_DEPARTMENTS BD
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_BILL_OF_MATERIALS BBOM
WHERE WDJ.WIP_ENTITY_ID = WSSJ.WIP_ENTITY_ID
AND WO.WIP_ENTITY_ID = WSSJ.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WSSJ.ORGANIZATION_ID
AND WO.REPETITIVE_SCHEDULE_ID IS NULL
AND WO.OPERATION_SEQ_NUM = WSSJ.OPERATION_SEQ_NUM
AND MFG.LOOKUP_TYPE = 'WIP_INTRAOPERATION_STEP'
AND MFG.LOOKUP_CODE = WSSJ.INTRAOPERATION_STEP
AND WSSJ.DEPARTMENT_ID = BD.DEPARTMENT_ID (+)
AND WSSJ.ROUTING_SEQ_ID = BOS.ROUTING_SEQUENCE_ID (+)
AND WSSJ.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID (+)
AND NVL(WSSJ.ROUTING_SEQ_ID
, -9999) = BOR.ROUTING_SEQUENCE_ID (+)
AND BOS.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
AND WSSJ.BILL_SEQUENCE_ID = BBOM.BILL_SEQUENCE_ID (+)