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_FLOW_SCHEDULE_EVENTS_V

Source

View Text - Preformatted


SELECT bos2.operation_seq_num||':'||bso.operation_code "NODE_LABEL", wfs.organization_id, wfs.line_id, /* pk */ wfs.wip_entity_id, /* pk */ bos2.operation_seq_num, /* pk */ bos2.operation_sequence_id, trunc(bos2.effectivity_date) effectivity_date, bos2.disable_date, bos.operation_sequence_id line_operation_sequence_id, /* fk */ bso.operation_code, bos2.operation_description, bos2.operation_lead_time_percent, bos2.department_id, bos2.standard_operation_id, bd.department_code, wfs.primary_item_id, wfs.schedule_number, wsg.schedule_group_name, wfs.build_sequence, wfs.end_item_unit_number, wfs.planned_quantity, wfs.alternate_bom_designator, wfs.alternate_routing_designator, wfs.bom_revision, wfs.bom_revision_date, wfs.routing_revision, wfs.routing_revision_date, mso.concatenated_segments "SALES_ORDER_NUMBER", pjm_project.all_proj_idtoname(wfs.project_id), pjm_project.all_task_idtoname(wfs.task_id), 2 "NODE_TYPE", msi.concatenated_segments "ASSEMBLY_NAME", wl.line_code, bso2.operation_code "LINE_OPERATION_CODE" from wip_lines wl, mtl_system_items_kfv msi, mtl_sales_orders_kfv mso, wip_schedule_groups wsg, bom_departments bd, 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 bd.department_id = bos2.department_id and wsg.organization_id (+) = wfs.organization_id and wsg.schedule_group_id (+) = wfs.schedule_group_id and mso.sales_order_id (+) = wfs.demand_source_header_id and msi.inventory_item_id = wfs.primary_item_id and msi.organization_id = wfs.organization_id and wl.line_id = wfs.line_id and wl.organization_id = wfs.organization_id and bso2.standard_operation_id = bos.standard_operation_id

View Text - HTML Formatted

SELECT BOS2.OPERATION_SEQ_NUM||':'||BSO.OPERATION_CODE "NODE_LABEL"
, WFS.ORGANIZATION_ID
, WFS.LINE_ID
, /* PK */ WFS.WIP_ENTITY_ID
, /* PK */ BOS2.OPERATION_SEQ_NUM
, /* PK */ BOS2.OPERATION_SEQUENCE_ID
, TRUNC(BOS2.EFFECTIVITY_DATE) EFFECTIVITY_DATE
, BOS2.DISABLE_DATE
, BOS.OPERATION_SEQUENCE_ID LINE_OPERATION_SEQUENCE_ID
, /* FK */ BSO.OPERATION_CODE
, BOS2.OPERATION_DESCRIPTION
, BOS2.OPERATION_LEAD_TIME_PERCENT
, BOS2.DEPARTMENT_ID
, BOS2.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, WFS.PRIMARY_ITEM_ID
, WFS.SCHEDULE_NUMBER
, WSG.SCHEDULE_GROUP_NAME
, WFS.BUILD_SEQUENCE
, WFS.END_ITEM_UNIT_NUMBER
, WFS.PLANNED_QUANTITY
, WFS.ALTERNATE_BOM_DESIGNATOR
, WFS.ALTERNATE_ROUTING_DESIGNATOR
, WFS.BOM_REVISION
, WFS.BOM_REVISION_DATE
, WFS.ROUTING_REVISION
, WFS.ROUTING_REVISION_DATE
, MSO.CONCATENATED_SEGMENTS "SALES_ORDER_NUMBER"
, PJM_PROJECT.ALL_PROJ_IDTONAME(WFS.PROJECT_ID)
, PJM_PROJECT.ALL_TASK_IDTONAME(WFS.TASK_ID)
, 2 "NODE_TYPE"
, MSI.CONCATENATED_SEGMENTS "ASSEMBLY_NAME"
, WL.LINE_CODE
, BSO2.OPERATION_CODE "LINE_OPERATION_CODE"
FROM WIP_LINES WL
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_SALES_ORDERS_KFV MSO
, WIP_SCHEDULE_GROUPS WSG
, BOM_DEPARTMENTS BD
, 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 BD.DEPARTMENT_ID = BOS2.DEPARTMENT_ID
AND WSG.ORGANIZATION_ID (+) = WFS.ORGANIZATION_ID
AND WSG.SCHEDULE_GROUP_ID (+) = WFS.SCHEDULE_GROUP_ID
AND MSO.SALES_ORDER_ID (+) = WFS.DEMAND_SOURCE_HEADER_ID
AND MSI.INVENTORY_ITEM_ID = WFS.PRIMARY_ITEM_ID
AND MSI.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND WL.LINE_ID = WFS.LINE_ID
AND WL.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND BSO2.STANDARD_OPERATION_ID = BOS.STANDARD_OPERATION_ID