VIEW: APPS.BOMFV_FLOW_ROUTING_EVENTS

Source

View Text - Preformatted

SELECT SQ1.OPERATION_SEQ_NUM SEQUENCE_NUMBER , SQ1.EFFECTIVITY_DATE EFFECTIVE_START_DATE , RT1.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE , PA1.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , '_KF:INV:MSTK:SY1' "_KF:ROUTING_ITEM_NAME" , SQ1.OPERATION_DESCRIPTION DESCRIPTION , SQ1.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY , SQ1.DISABLE_DATE END_EFFECTIVE_DATE , SQ1.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT , '_LA:SQ1.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING' , '_LA:SQ1.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:SQ1.OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:SQ1.REFERENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , SQ1.YIELD OPERATION_YIELD , SQ1.CUMULATIVE_YIELD OPERATION_CUMULATIVE_YIELD , SQ1.REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD , SQ1.LABOR_TIME_CALC CALCULATED_LABOR_TIME , SQ1.MACHINE_TIME_CALC CALCULATED_MACHINE_TIME, SQ1.TOTAL_TIME_CALC CALCULATED_ELAPSED_TIME , SQ1.LABOR_TIME_USER ENTERED_LABOR_TIME , SQ1.MACHINE_TIME_USER ENTERED_MACHINE_TIME , SQ1.TOTAL_TIME_USER USER_ELAPSED_TIME , SQ1.NET_PLANNING_PERCENT NET_PLANNING_PERCENT , '_KF:INV:MSTK:SY2' "_KF:PROCESS_NAME" , '_KF:INV:MSTK:SY3' "_KF:LINE_OPERATION_NAME" , OP.OPERATION_CODE OPERATION_CODE , RT2.ALTERNATE_ROUTING_DESIGNATOR LINEOP_ALTERNATE_ROUTING_CODE , RT3.ALTERNATE_ROUTING_DESIGNATOR PROCESS_ALTERNATE_RTG_CODE , DE.DEPARTMENT_CODE DEPARTMENT_CODE , RT1.ROUTING_SEQUENCE_ID , SQ1.OPERATION_SEQUENCE_ID , SQ1.STANDARD_OPERATION_ID , SQ1.DEPARTMENT_ID , SQ1.LINE_OP_SEQ_ID , SQ1.PROCESS_OP_SEQ_ID , SQ1.LAST_UPDATE_DATE UPDATED_ON , SQ1.LAST_UPDATED_BY UPDATED_BY , SQ1.CREATION_DATE CREATED_ON , SQ1.CREATED_BY FROM BOM_DEPARTMENTS DE,BOM_STANDARD_OPERATIONS OP,BOM_OPERATION_SEQUENCES SQ3,MTL_SYSTEM_ITEMS_B SY3,BOM_OPERATIONAL_ROUTINGS RT3,MTL_SYSTEM_ITEMS_B SY2,BOM_OPERATIONAL_ROUTINGS RT2,BOM_OPERATION_SEQUENCES SQ2,HR_ALL_ORGANIZATION_UNITS AL,MTL_PARAMETERS PA1,MTL_SYSTEM_ITEMS_B SY1,BOM_OPERATIONAL_ROUTINGS RT1,BOM_OPERATION_SEQUENCES SQ1 WHERE SQ1.DEPARTMENT_ID = DE.DEPARTMENT_ID AND RT2.ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+) AND RT2.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+) AND SQ2.ROUTING_SEQUENCE_ID = RT2.ROUTING_SEQUENCE_ID(+) AND SQ1.LINE_OP_SEQ_ID = SQ2.OPERATION_SEQUENCE_ID(+) AND RT3.ASSEMBLY_ITEM_ID = SY3.INVENTORY_ITEM_ID(+) AND RT3.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+) AND SQ3.ROUTING_SEQUENCE_ID = RT3.ROUTING_SEQUENCE_ID(+) AND SQ1.PROCESS_OP_SEQ_ID = SQ3.OPERATION_SEQUENCE_ID(+) AND SQ1.STANDARD_OPERATION_ID = OP.STANDARD_OPERATION_ID(+) AND RT1.ORGANIZATION_ID = PA1.ORGANIZATION_ID AND RT1.ORGANIZATION_ID = AL.ORGANIZATION_ID AND RT1.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID AND RT1.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND RT1.CFM_ROUTING_FLAG=1 AND SQ1.ROUTING_SEQUENCE_ID = RT1.COMMON_ROUTING_SEQUENCE_ID AND SQ1.OPERATION_TYPE=1 AND '_SEC:RT1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT SQ1.OPERATION_SEQ_NUM SEQUENCE_NUMBER
, SQ1.EFFECTIVITY_DATE EFFECTIVE_START_DATE
, RT1.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE
, PA1.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY1' "_KF:ROUTING_ITEM_NAME"
, SQ1.OPERATION_DESCRIPTION DESCRIPTION
, SQ1.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, SQ1.DISABLE_DATE END_EFFECTIVE_DATE
, SQ1.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT
, '_LA:SQ1.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING'
, '_LA:SQ1.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:SQ1.OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:SQ1.REFERENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, SQ1.YIELD OPERATION_YIELD
, SQ1.CUMULATIVE_YIELD OPERATION_CUMULATIVE_YIELD
, SQ1.REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD
, SQ1.LABOR_TIME_CALC CALCULATED_LABOR_TIME
, SQ1.MACHINE_TIME_CALC CALCULATED_MACHINE_TIME
, SQ1.TOTAL_TIME_CALC CALCULATED_ELAPSED_TIME
, SQ1.LABOR_TIME_USER ENTERED_LABOR_TIME
, SQ1.MACHINE_TIME_USER ENTERED_MACHINE_TIME
, SQ1.TOTAL_TIME_USER USER_ELAPSED_TIME
, SQ1.NET_PLANNING_PERCENT NET_PLANNING_PERCENT
, '_KF:INV:MSTK:SY2' "_KF:PROCESS_NAME"
, '_KF:INV:MSTK:SY3' "_KF:LINE_OPERATION_NAME"
, OP.OPERATION_CODE OPERATION_CODE
, RT2.ALTERNATE_ROUTING_DESIGNATOR LINEOP_ALTERNATE_ROUTING_CODE
, RT3.ALTERNATE_ROUTING_DESIGNATOR PROCESS_ALTERNATE_RTG_CODE
, DE.DEPARTMENT_CODE DEPARTMENT_CODE
, RT1.ROUTING_SEQUENCE_ID
, SQ1.OPERATION_SEQUENCE_ID
, SQ1.STANDARD_OPERATION_ID
, SQ1.DEPARTMENT_ID
, SQ1.LINE_OP_SEQ_ID
, SQ1.PROCESS_OP_SEQ_ID
, SQ1.LAST_UPDATE_DATE UPDATED_ON
, SQ1.LAST_UPDATED_BY UPDATED_BY
, SQ1.CREATION_DATE CREATED_ON
, SQ1.CREATED_BY
FROM BOM_DEPARTMENTS DE
, BOM_STANDARD_OPERATIONS OP
, BOM_OPERATION_SEQUENCES SQ3
, MTL_SYSTEM_ITEMS_B SY3
, BOM_OPERATIONAL_ROUTINGS RT3
, MTL_SYSTEM_ITEMS_B SY2
, BOM_OPERATIONAL_ROUTINGS RT2
, BOM_OPERATION_SEQUENCES SQ2
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA1
, MTL_SYSTEM_ITEMS_B SY1
, BOM_OPERATIONAL_ROUTINGS RT1
, BOM_OPERATION_SEQUENCES SQ1
WHERE SQ1.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND RT2.ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND RT2.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND SQ2.ROUTING_SEQUENCE_ID = RT2.ROUTING_SEQUENCE_ID(+)
AND SQ1.LINE_OP_SEQ_ID = SQ2.OPERATION_SEQUENCE_ID(+)
AND RT3.ASSEMBLY_ITEM_ID = SY3.INVENTORY_ITEM_ID(+)
AND RT3.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+)
AND SQ3.ROUTING_SEQUENCE_ID = RT3.ROUTING_SEQUENCE_ID(+)
AND SQ1.PROCESS_OP_SEQ_ID = SQ3.OPERATION_SEQUENCE_ID(+)
AND SQ1.STANDARD_OPERATION_ID = OP.STANDARD_OPERATION_ID(+)
AND RT1.ORGANIZATION_ID = PA1.ORGANIZATION_ID
AND RT1.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RT1.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND RT1.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND RT1.CFM_ROUTING_FLAG=1
AND SQ1.ROUTING_SEQUENCE_ID = RT1.COMMON_ROUTING_SEQUENCE_ID
AND SQ1.OPERATION_TYPE=1
AND '_SEC:RT1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY