VIEW: APPS.WIP_PCB_FLOW_SCHEDULE_EVENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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