View: WIP_OSP_DEST_OPERATION_V

Product:	WIP - Work in Process
Description:	Destination operation for outside processing resources
Implementation/DBA Data:	APPS.WIP_OSP_DEST_OPERATION_V

View Text

SELECT WO.WIP_ENTITY_ID
, WO.ORGANIZATION_ID
, WO.OPERATION_SEQ_NUM
, WO.REPETITIVE_SCHEDULE_ID
, WR.RESOURCE_SEQ_NUM
, WN.OPERATION_SEQ_NUM DEST_OPERATION_SEQ_NUM
, BD.DEPARTMENT_CODE DEST_DEPARTMENT_CODE
, WN.DEPARTMENT_ID DEST_DEPARTMENT_ID
FROM BOM_DEPARTMENTS BD
, WIP_OPERATION_RESOURCES WR
, WIP_OPERATIONS WN
, WIP_OPERATIONS WO
WHERE WO.WIP_ENTITY_ID = WN.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WN.ORGANIZATION_ID
AND NVL(WO.REPETITIVE_SCHEDULE_ID
, -1) = NVL(WN.REPETITIVE_SCHEDULE_ID
, -1)
AND WN.OPERATION_SEQ_NUM = DECODE (WR.AUTOCHARGE_TYPE
, 4
, NVL(WO.NEXT_OPERATION_SEQ_NUM
, WO.OPERATION_SEQ_NUM)
, WO.OPERATION_SEQ_NUM)
AND WO.WIP_ENTITY_ID = WR.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WR.ORGANIZATION_ID
AND NVL(WO.REPETITIVE_SCHEDULE_ID
, -1) = NVL(WR.REPETITIVE_SCHEDULE_ID
, -1)
AND WO.OPERATION_SEQ_NUM = WR.OPERATION_SEQ_NUM
AND WR.AUTOCHARGE_TYPE IN (3
, 4)
AND BD.DEPARTMENT_ID = WN.DEPARTMENT_ID

Columns