View: BOMFV_ROUTINGS

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

View Text

SELECT OP.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY' "_KF:ITEM_NAME"
, OP.TOTAL_PRODUCT_CYCLE_TIME TOTAL_CYCLE_TIME
, OP.PRIORITY ROUTING_PRIORITY
, OP.ROUTING_COMMENT "COMMENT"
, '_LA:OP.ROUTING_TYPE:MFG_LOOKUPS:BOM_NO_YES:MEANING'
, '_LA:OP.MIXED_MODEL_MAP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:OP.CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:OP.CFM_ROUTING_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP2.ALTERNATE_ROUTING_DESIGNATOR COMMON_ALTERNATE_ROUTING_CODE
, '_KF:INV:MSTK:SY2' "_KF:COMMON_ROUTING_NAME"
, '_KF:INV:MTLL:LO' "_KF:COMPLETION_LOCATOR_CODE"
, LI.LINE_CODE LINE_NAME
, PR.NAME PROJECT_NAME
, TA.TASK_NAME TASK_NAME
, '_DF:BOM:BOM_OPERATIONAL_ROUTINGS:OP'
, OP.ROUTING_SEQUENCE_ID
, OP.ORGANIZATION_ID
, OP.COMMON_ASSEMBLY_ITEM_ID
, OP.ASSEMBLY_ITEM_ID
, OP.COMMON_ROUTING_SEQUENCE_ID
, OP.COMPLETION_SUBINVENTORY
, OP.COMPLETION_LOCATOR_ID
, OP.LINE_ID
, OP.PROJECT_ID
, OP.TASK_ID
, OP.CREATED_BY
, OP.CREATION_DATE CREATED_ON
, OP.LAST_UPDATE_DATE UPDATED_ON
, OP.LAST_UPDATED_BY UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY2
, BOM_OPERATIONAL_ROUTINGS OP2
, MTL_ITEM_LOCATIONS LO
, HR_ALL_ORGANIZATION_UNITS AL
, WIP_LINES LI
, PA_PROJECTS_ALL PR
, PA_TASKS TA
, BOM_OPERATIONAL_ROUTINGS OP
WHERE OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OP.LINE_ID = LI.LINE_ID(+)
AND OP2.COMMON_ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND OP2.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND OP.COMMON_ROUTING_SEQUENCE_ID = OP2.ROUTING_SEQUENCE_ID(+)
AND OP.COMPLETION_LOCATOR_ID = LO.INVENTORY_LOCATION_ID(+)
AND OP.ORGANIZATION_ID = LO.ORGANIZATION_ID (+)
AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.PROJECT_ID = PR.PROJECT_ID(+)
AND OP.TASK_ID = TA.TASK_ID (+)
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns