DBA Data[Home] [Help]

VIEW: APPS.BOMBV_FLOW_ROUTING_EVENTS

Source

View Text - Preformatted

SELECT EV.OPERATION_SEQ_NUM SEQUENCE_NUMBER , EV.EFFECTIVITY_DATE START_EFFECTIVE_DATE , OP.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME" , EV.OPERATION_DESCRIPTION DESCRIPTION , EV.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY , EV.DISABLE_DATE END_EFFECTIVE_DATE , EV.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT , EV.YIELD OPERATION_YIELD , EV.CUMULATIVE_YIELD OPERATION_CUMULATIVE_YIELD , EV.REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD , EV.LABOR_TIME_CALC CALCULATED_LABOR_TIME , EV.MACHINE_TIME_CALC CALCULATED_MACHINE_TIME , EV.TOTAL_TIME_CALC CALCULATED_ELAPSED_TIME , EV.LABOR_TIME_USER ENTERED_LABOR_TIME , EV.MACHINE_TIME_USER ENTERED_MACHINE_TIME , EV.TOTAL_TIME_USER USER_ELAPSED_TIME , EV.NET_PLANNING_PERCENT NET_PLANNING_PERCENT , '_LA:EV.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING', '_LA:EV.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:EV.OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:EV.REFERENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , OP.ROUTING_SEQUENCE_ID , EV.OPERATION_SEQUENCE_ID , EV.STANDARD_OPERATION_ID , EV.DEPARTMENT_ID , EV.LINE_OP_SEQ_ID , EV.PROCESS_OP_SEQ_ID , EV.LAST_UPDATE_DATE UPDATED_ON , EV.LAST_UPDATED_BY UPDATED_BY , EV.CREATION_DATE CREATED_ON , EV.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL,MTL_SYSTEM_ITEMS_B SY,BOM_OPERATIONAL_ROUTINGS OP,MTL_PARAMETERS PA,BOM_OPERATION_SEQUENCES EV WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID AND OP.CFM_ROUTING_FLAG = 1 AND EV.ROUTING_SEQUENCE_ID = OP.COMMON_ROUTING_SEQUENCE_ID AND EV.OPERATION_TYPE = 1 AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
View Text - HTML Formatted

SELECT EV.OPERATION_SEQ_NUM SEQUENCE_NUMBER
, EV.EFFECTIVITY_DATE START_EFFECTIVE_DATE
, OP.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME"
, EV.OPERATION_DESCRIPTION DESCRIPTION
, EV.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, EV.DISABLE_DATE END_EFFECTIVE_DATE
, EV.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT
, EV.YIELD OPERATION_YIELD
, EV.CUMULATIVE_YIELD OPERATION_CUMULATIVE_YIELD
, EV.REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD
, EV.LABOR_TIME_CALC CALCULATED_LABOR_TIME
, EV.MACHINE_TIME_CALC CALCULATED_MACHINE_TIME
, EV.TOTAL_TIME_CALC CALCULATED_ELAPSED_TIME
, EV.LABOR_TIME_USER ENTERED_LABOR_TIME
, EV.MACHINE_TIME_USER ENTERED_MACHINE_TIME
, EV.TOTAL_TIME_USER USER_ELAPSED_TIME
, EV.NET_PLANNING_PERCENT NET_PLANNING_PERCENT
, '_LA:EV.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING'
, '_LA:EV.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:EV.OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:EV.REFERENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP.ROUTING_SEQUENCE_ID
, EV.OPERATION_SEQUENCE_ID
, EV.STANDARD_OPERATION_ID
, EV.DEPARTMENT_ID
, EV.LINE_OP_SEQ_ID
, EV.PROCESS_OP_SEQ_ID
, EV.LAST_UPDATE_DATE UPDATED_ON
, EV.LAST_UPDATED_BY UPDATED_BY
, EV.CREATION_DATE CREATED_ON
, EV.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS_B SY
, BOM_OPERATIONAL_ROUTINGS OP
, MTL_PARAMETERS PA
, BOM_OPERATION_SEQUENCES EV
WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND OP.CFM_ROUTING_FLAG = 1
AND EV.ROUTING_SEQUENCE_ID = OP.COMMON_ROUTING_SEQUENCE_ID
AND EV.OPERATION_TYPE = 1
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY