View: BOMBV_ROUTINGS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMBV_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"
, '_LA:ROUTING_TYPE:MFG_LOOKUPS:BOM_NO_YES:MEANING'
, '_LA:MIXED_MODEL_MAP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CFM_ROUTING_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP.ROUTING_COMMENT "COMMENT"
, OP.PRIORITY ROUTING_PRIORITY
, OP.TOTAL_PRODUCT_CYCLE_TIME TOTAL_CYCLE_TIME
, OP.ROUTING_SEQUENCE_ID 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 HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY
, BOM_OPERATIONAL_ROUTINGS OP
WHERE OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns