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_RTG_OPRATNS

Source

View Text - Preformatted


SELECT SQ.OPERATION_SEQ_NUM SEQUENCE_NUMBER , SQ.EFFECTIVITY_DATE START_EFFECTIVE_DATE , OP.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME" , SQ.OPERATION_DESCRIPTION DESCRIPTION , SQ.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY , SQ.DISABLE_DATE END_EFFECTIVE_DATE , SQ.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT , SQ.YIELD OPERATION_YIELD , '_LA:COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING' , '_LA:BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:REFERENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , SQ.ROUTING_SEQUENCE_ID , SQ.OPERATION_SEQUENCE_ID , SQ.STANDARD_OPERATION_ID , SQ.DEPARTMENT_ID , SQ.LAST_UPDATE_DATE UPDATED_ON , SQ.LAST_UPDATED_BY UPDATED_BY , SQ.CREATION_DATE CREATED_ON , SQ.CREATED_BY FROM BOM_OPERATIONAL_ROUTINGS OP, MTL_PARAMETERS PA, MTL_SYSTEM_ITEMS SY, HR_ALL_ORGANIZATION_UNITS AL, BOM_OPERATION_SEQUENCES SQ WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID AND ( OP.CFM_ROUTING_FLAG = 2 OR OP.CFM_ROUTING_FLAG IS NULL ) AND SQ.ROUTING_SEQUENCE_ID = OP.COMMON_ROUTING_SEQUENCE_ID AND ( SQ.OPERATION_TYPE = 1 OR SQ.OPERATION_TYPE IS NULL ) AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT SQ.OPERATION_SEQ_NUM SEQUENCE_NUMBER
, SQ.EFFECTIVITY_DATE START_EFFECTIVE_DATE
, OP.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME"
, SQ.OPERATION_DESCRIPTION DESCRIPTION
, SQ.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, SQ.DISABLE_DATE END_EFFECTIVE_DATE
, SQ.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT
, SQ.YIELD OPERATION_YIELD
, '_LA:COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING'
, '_LA:BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:REFERENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, SQ.ROUTING_SEQUENCE_ID
, SQ.OPERATION_SEQUENCE_ID
, SQ.STANDARD_OPERATION_ID
, SQ.DEPARTMENT_ID
, SQ.LAST_UPDATE_DATE UPDATED_ON
, SQ.LAST_UPDATED_BY UPDATED_BY
, SQ.CREATION_DATE CREATED_ON
, SQ.CREATED_BY
FROM BOM_OPERATIONAL_ROUTINGS OP
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_OPERATION_SEQUENCES SQ
WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND ( OP.CFM_ROUTING_FLAG = 2 OR OP.CFM_ROUTING_FLAG IS NULL )
AND SQ.ROUTING_SEQUENCE_ID = OP.COMMON_ROUTING_SEQUENCE_ID
AND ( SQ.OPERATION_TYPE = 1 OR SQ.OPERATION_TYPE IS NULL )
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY