eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BOM_OPERATIONAL_ROUTINGS_ERV

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')