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_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)