View: BOMBV_FLOW_ROUTING_PROCESSES

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

View Text

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

Columns