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_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:MIXED_MODEL_MAP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:CFM_ROUTING_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , OP.ROUTING_COMMENT "COMMENT" , OP.PRIORITY ROUTING_PRIORITY , OP.TOTAL_PRODUCT_CYCLE_TIME TOTAL_CYCLE_TIME , OP.ROUTING_SEQUENCE_ID 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.LINE_ID , OP.PROJECT_ID , OP.TASK_ID , OP.CREATED_BY , OP.CREATION_DATE CREATED_ON , OP.LAST_UPDATE_DATE UPDATED_ON , OP.LAST_UPDATED_BY UPDATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL, MTL_PARAMETERS PA, MTL_SYSTEM_ITEMS SY, BOM_OPERATIONAL_ROUTINGS OP WHERE OP.ORGANIZATION_ID = AL.ORGANIZATION_ID AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID 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:MIXED_MODEL_MAP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CFM_ROUTING_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP.ROUTING_COMMENT "COMMENT"
, OP.PRIORITY ROUTING_PRIORITY
, OP.TOTAL_PRODUCT_CYCLE_TIME TOTAL_CYCLE_TIME
, OP.ROUTING_SEQUENCE_ID 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.LINE_ID
, OP.PROJECT_ID
, OP.TASK_ID
, OP.CREATED_BY
, OP.CREATION_DATE CREATED_ON
, OP.LAST_UPDATE_DATE UPDATED_ON
, OP.LAST_UPDATED_BY UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY
, BOM_OPERATIONAL_ROUTINGS OP
WHERE OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY