VIEW: APPS.WIP_OSP_DEST_OPERATION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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