View: BOMFV_FLOW_ROUTING_EVENTS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMFV_FLOW_ROUTING_EVENTS

View Text

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

Columns