View: WIP_PCB_FLOW_SCHEDULE_EVENTS_V

Product:	WIP - Work in Process
Description:	WIP Production Control Board base view
Implementation/DBA Data:	APPS.WIP_PCB_FLOW_SCHEDULE_EVENTS_V

View Text

SELECT WFS.ORGANIZATION_ID
, WFS.LINE_ID
, WFS.WIP_ENTITY_ID
, BOS.OPERATION_SEQUENCE_ID LINE_OPERATION_SEQUENCE_ID
, 2
, BOS2.OPERATION_SEQ_NUM
, BOS2.OPERATION_SEQ_NUM||':'||BSO.OPERATION_CODE "NODE_LABEL"
, BSO.OPERATION_CODE
FROM BOM_STANDARD_OPERATIONS BSO2 /* FOR LINE OPERATION */
, BOM_STANDARD_OPERATIONS BSO
, BOM_OPERATION_SEQUENCES BOS2
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, WIP_FLOW_SCHEDULES WFS
WHERE BOR.ORGANIZATION_ID = WFS.ORGANIZATION_ID AND BOR.ASSEMBLY_ITEM_ID = WFS.PRIMARY_ITEM_ID AND BOR.LINE_ID = WFS.LINE_ID AND BOR.CFM_ROUTING_FLAG = 1 AND DECODE(BOR.ALTERNATE_ROUTING_DESIGNATOR
, NULL
, '@@@@@@@'
, BOR.ALTERNATE_ROUTING_DESIGNATOR) = DECODE(WFS.ALTERNATE_ROUTING_DESIGNATOR
, NULL
, '@@@@@@@'
, WFS.ALTERNATE_ROUTING_DESIGNATOR) AND BOS.OPERATION_TYPE = 3 /* LINE OPERATION */ AND BOS.ROUTING_SEQUENCE_ID = BOR.COMMON_ROUTING_SEQUENCE_ID AND BOS2.LINE_OP_SEQ_ID = BOS.OPERATION_SEQUENCE_ID AND TRUNC(BOS2.EFFECTIVITY_DATE) <= TRUNC(NVL(WFS.ROUTING_REVISION_DATE
, SYSDATE)) AND (BOS2.DISABLE_DATE IS NULL OR TRUNC(BOS2.DISABLE_DATE) > TRUNC(WFS.ROUTING_REVISION_DATE)) AND BSO.STANDARD_OPERATION_ID (+) = BOS2.STANDARD_OPERATION_ID AND BSO2.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID WITH READ ONLY

Columns