View: BOM_OPERATIONAL_ROUTINGS_ERV

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

View Text

SELECT BOR.ROWID
, ORG2.ORGANIZATION_CODE
, ORG1.NAME
, NULL
, ITEMS.CONCATENATED_SEGMENTS
, ITEMS.DESCRIPTION
, ITEMS.PRIMARY_UOM_CODE
, BOR.ALTERNATE_ROUTING_DESIGNATOR
, REV.PROCESS_REVISION
, BOR.PRIORITY
, FLEX.ITEM_NUMBER
, BOR.SERIALIZATION_START_OP
, BOR.COMPLETION_SUBINVENTORY
, LOC.CONCATENATED_SEGMENTS LOCATOR
, BOR.ROUTING_COMMENT
, ITEMS2.CONCATENATED_SEGMENTS COMMON_ITEM
, ITEMS2.DESCRIPTION COMMON_ITEM_DESCRIPTION
, BOR.ORGANIZATION_ID
, BOR.ASSEMBLY_ITEM_ID
, BOR.ROUTING_SEQUENCE_ID
, 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
, 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)
, 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
FROM WIP_LINES WL
, MTL_ITEM_FLEXFIELDS FLEX
, MTL_SYSTEM_ITEMS_VL ITEMS
, MTL_SYSTEM_ITEMS_VL ITEMS2
, BOM_OPERATIONAL_ROUTINGS BOR
, MTL_SECONDARY_INVENTORIES MSI
, HR_ALL_ORGANIZATION_UNITS_TL ORG1
, MTL_PARAMETERS ORG2
, MTL_RTG_ITEM_REVISIONS REV
, MTL_ITEM_LOCATIONS_KFV LOC
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 (+)
AND BOR.COMMON_ASSEMBLY_ITEM_ID = ITEMS2.INVENTORY_ITEM_ID (+)
AND BOR.ORGANIZATION_ID = ITEMS2.ORGANIZATION_ID (+)
AND ORG1.ORGANIZATION_ID = BOR.ORGANIZATION_ID
AND ORG2.ORGANIZATION_ID = BOR.ORGANIZATION_ID
AND REV.ORGANIZATION_ID = BOR.ORGANIZATION_ID
AND REV.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND (REV.EFFECTIVITY_DATE IS NULL OR REV.EFFECTIVITY_DATE = (SELECT MAX (EFFECTIVITY_DATE)
FROM MTL_RTG_ITEM_REVISIONS
WHERE INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ORGANIZATION_ID = BOR.ORGANIZATION_ID) )
AND BOR.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+)
AND BOR.COMPLETION_SUBINVENTORY = LOC.SUBINVENTORY_CODE (+)
AND BOR.COMPLETION_LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+)
AND ORG1.LANGUAGE(+) = USERENV('LANG')

Columns