View: BOM_OPERATIONAL_ROUTINGS_V

Product:	BOM - Bills of Material
Description:	Routings
Implementation/DBA Data:	APPS.BOM_OPERATIONAL_ROUTINGS_V

View Text

SELECT BOR.ROWID ROW_ID
, BOR.ROUTING_SEQUENCE_ID
, BOR.ASSEMBLY_ITEM_ID
, BOR.ORGANIZATION_ID
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, BOR.LAST_UPDATE_DATE
, BOR.LAST_UPDATED_BY
, BOR.CREATION_DATE
, BOR.CREATED_BY
, BOR.LAST_UPDATE_LOGIN
, BOR.ROUTING_TYPE
, BOR.COMMON_ASSEMBLY_ITEM_ID
, BOR.COMMON_ROUTING_SEQUENCE_ID
, BOR.ROUTING_COMMENT
, BOR.COMPLETION_SUBINVENTORY
, NVL(MSI.LOCATOR_TYPE
, 1) SUB_LOCATOR_CONTROL
, BOR.COMPLETION_LOCATOR_ID
, BOR.ATTRIBUTE_CATEGORY
, BOR.ATTRIBUTE1
, BOR.ATTRIBUTE2
, BOR.ATTRIBUTE3
, BOR.ATTRIBUTE4
, BOR.ATTRIBUTE5
, BOR.ATTRIBUTE6
, BOR.ATTRIBUTE7
, BOR.ATTRIBUTE8
, BOR.ATTRIBUTE9
, BOR.ATTRIBUTE10
, BOR.ATTRIBUTE11
, BOR.ATTRIBUTE12
, BOR.ATTRIBUTE13
, BOR.ATTRIBUTE14
, BOR.ATTRIBUTE15
, BOR.REQUEST_ID
, BOR.PROGRAM_APPLICATION_ID
, BOR.PROGRAM_ID
, BOR.PROGRAM_UPDATE_DATE
, BOR.LINE_ID
, WL.LINE_CODE
, BOR.CFM_ROUTING_FLAG
, NVL(BOR.MIXED_MODEL_MAP_FLAG
, 2)
, BOR.PRIORITY
, ITEMS.PRODUCT_FAMILY_ITEM_ID
, FLEX.ITEM_NUMBER
, NVL( BOR.CTP_FLAG
, 2)
, BOR.TOTAL_PRODUCT_CYCLE_TIME
, BOR.PENDING_FROM_ECN
, BOR.ORIGINAL_SYSTEM_REFERENCE
, ITEMS.EAM_ITEM_TYPE
, BOR.SERIALIZATION_START_OP
, ITEMS.DESCRIPTION
, ITEMS.PRIMARY_UOM_CODE UOM
FROM WIP_LINES WL
, MTL_ITEM_FLEXFIELDS FLEX
, MTL_SYSTEM_ITEMS ITEMS
, BOM_OPERATIONAL_ROUTINGS BOR
, MTL_SECONDARY_INVENTORIES MSI
WHERE BOR.COMPLETION_SUBINVENTORY = MSI.SECONDARY_INVENTORY_NAME (+)
AND BOR.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND BOR.LINE_ID = WL.LINE_ID (+)
AND BOR.ASSEMBLY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND BOR.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND ITEMS.PRODUCT_FAMILY_ITEM_ID = FLEX.INVENTORY_ITEM_ID (+)
AND ITEMS.ORGANIZATION_ID = FLEX.ORGANIZATION_ID (+)

Columns