eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WIP_PCB_OPEN_FLOW_SCHEDULES_V

Source

View Text - Preformatted


SELECT wfs.organization_id , wfs.line_id , wfs.wip_entity_id , bos.operation_sequence_id , 1 , msik.concatenated_segments||':'|| wip_sfcb_utilities.date_to_displaydate_tz(wfs.scheduled_completion_date)||':'|| wsg.schedule_group_name||':'||wfs.build_sequence "NODE_LABEL" , wfs.scheduled_completion_date , wsg.schedule_group_name , wfs.build_sequence , msik.concatenated_segments , bos.standard_operation_id FROM mtl_system_items_kfv msik , wip_schedule_groups wsg , bom_operation_sequences bos , bom_operational_routings bor , wip_flow_schedules wfs WHERE wfs.scheduled_flag = 1 and 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 NVL(bos.operation_type, 1) = 3 /* line operation */ and bos.routing_sequence_id = bor.common_routing_sequence_id and wsg.organization_id (+) = wfs.organization_id and wsg.schedule_group_id (+) = wfs.schedule_group_id and msik.organization_id = wfs.organization_id and msik.inventory_item_id = wfs.primary_item_id and wfs.status <> 2 and WIP_SFCB_Utilities.line_op_is_pending ( BOS.operation_seq_num, BOR.common_routing_sequence_id, WFS.primary_item_id, WFS.organization_id, WFS.alternate_routing_designator, WFS.current_line_operation /* will change to current line operation */ ) = 1 with read only

View Text - HTML Formatted

SELECT WFS.ORGANIZATION_ID
, WFS.LINE_ID
, WFS.WIP_ENTITY_ID
, BOS.OPERATION_SEQUENCE_ID
, 1
, MSIK.CONCATENATED_SEGMENTS||':'|| WIP_SFCB_UTILITIES.DATE_TO_DISPLAYDATE_TZ(WFS.SCHEDULED_COMPLETION_DATE)||':'|| WSG.SCHEDULE_GROUP_NAME||':'||WFS.BUILD_SEQUENCE "NODE_LABEL"
, WFS.SCHEDULED_COMPLETION_DATE
, WSG.SCHEDULE_GROUP_NAME
, WFS.BUILD_SEQUENCE
, MSIK.CONCATENATED_SEGMENTS
, BOS.STANDARD_OPERATION_ID
FROM MTL_SYSTEM_ITEMS_KFV MSIK
, WIP_SCHEDULE_GROUPS WSG
, BOM_OPERATION_SEQUENCES BOS
, BOM_OPERATIONAL_ROUTINGS BOR
, WIP_FLOW_SCHEDULES WFS
WHERE WFS.SCHEDULED_FLAG = 1
AND 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 NVL(BOS.OPERATION_TYPE
, 1) = 3 /* LINE OPERATION */
AND BOS.ROUTING_SEQUENCE_ID = BOR.COMMON_ROUTING_SEQUENCE_ID
AND WSG.ORGANIZATION_ID (+) = WFS.ORGANIZATION_ID
AND WSG.SCHEDULE_GROUP_ID (+) = WFS.SCHEDULE_GROUP_ID
AND MSIK.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND MSIK.INVENTORY_ITEM_ID = WFS.PRIMARY_ITEM_ID
AND WFS.STATUS <> 2
AND WIP_SFCB_UTILITIES.LINE_OP_IS_PENDING ( BOS.OPERATION_SEQ_NUM
, BOR.COMMON_ROUTING_SEQUENCE_ID
, WFS.PRIMARY_ITEM_ID
, WFS.ORGANIZATION_ID
, WFS.ALTERNATE_ROUTING_DESIGNATOR
, WFS.CURRENT_LINE_OPERATION /* WILL CHANGE TO CURRENT LINE OPERATION */ ) = 1 WITH READ ONLY