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.BOMBV_WORK_ORDER_ROUTINGS

Source

View Text - Preformatted


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:CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , OP.PRIORITY ROUTING_PRIORITY , OP.ROUTING_COMMENT "COMMENT" , OP.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.CREATED_BY , OP.CREATION_DATE CREATED_ON , OP.LAST_UPDATE_DATE UPDATED_ON , OP.LAST_UPDATED_BY UPDATED_BY FROM MTL_SYSTEM_ITEMS SY, MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, BOM_OPERATIONAL_ROUTINGS OP WHERE OP.ORGANIZATION_ID = SY.ORGANIZATION_ID AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID AND OP.ORGANIZATION_ID =AL.ORGANIZATION_ID AND (OP.CFM_ROUTING_FLAG IS NULL OR OP.CFM_ROUTING_FLAG =2 ) AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

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:CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP.PRIORITY ROUTING_PRIORITY
, OP.ROUTING_COMMENT "COMMENT"
, OP.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.CREATED_BY
, OP.CREATION_DATE CREATED_ON
, OP.LAST_UPDATE_DATE UPDATED_ON
, OP.LAST_UPDATED_BY UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_OPERATIONAL_ROUTINGS OP
WHERE OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OP.ORGANIZATION_ID =AL.ORGANIZATION_ID
AND (OP.CFM_ROUTING_FLAG IS NULL OR OP.CFM_ROUTING_FLAG =2 )
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY