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.

[Home] [Help]

View: BOMFV_FLOW_RTG_LINE_OPERATIONS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMFV_FLOW_RTG_LINE_OPERATIONS

View Text

SELECT SQ.OPERATION_SEQ_NUM SEQUENCE_NUMBER
, RT.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE
, SQ.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, 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.OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT
, SQ.DISABLE_DATE END_EFFECTIVITY_DATE
, SQ.YIELD OPERATION_YIELD
, SQ.CUMULATIVE_YIELD OPERATION_CUMULATIVE_YIELD
, SQ.REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD
, SQ.LABOR_TIME_CALC CALCULATED_LABOR_TIME
, SQ.MACHINE_TIME_CALC CALCULATED_MACHINE_TIME
, SQ.TOTAL_TIME_CALC CALCULATED_ELAPSED_TIME
, SQ.LABOR_TIME_USER ENTERED_LABOR_TIME
, SQ.MACHINE_TIME_USER ENTERED_MACHINE_TIME
, SQ.TOTAL_TIME_USER USER_ELAPSED_TIME
, SQ.NET_PLANNING_PERCENT NET_PLANNING_PERCENT
, '_LA:SQ.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING'
, '_LA:SQ.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:SQ.OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:SQ.REFERENCE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP.OPERATION_CODE OPERATION_CODE
, DE.DEPARTMENT_CODE
, RT.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_STANDARD_OPERATIONS OP
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS_B SY
, BOM_DEPARTMENTS DE
, MTL_PARAMETERS PA
, BOM_OPERATIONAL_ROUTINGS RT
, BOM_OPERATION_SEQUENCES SQ
WHERE SQ.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND SQ.STANDARD_OPERATION_ID = OP.STANDARD_OPERATION_ID(+)
AND RT.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RT.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RT.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND RT.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND RT.CFM_ROUTING_FLAG=1
AND SQ.ROUTING_SEQUENCE_ID = RT.COMMON_ROUTING_SEQUENCE_ID
AND SQ.OPERATION_TYPE=3
AND '_SEC:RT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
SEQUENCE_NUMBER
ALTERNATE_ROUTING_CODE
START_EFFECTIVE_DATE
ORGANIZATION_CODE
ORGANIZATION_NAME
"_KF:ROUTING_ITEM_NAME"
DESCRIPTION
MINIMUM_TRANSFER_QUANTITY
OPERATION_LEAD_TIME_PERCENT
END_EFFECTIVE_DATE
OPERATION_YIELD
OPERATION_CUMULATIVE_YIELD
REVERSE_CUMULATIVE_YIELD
CALCULATED_LABOR_TIME
CALCULATED_MACHINE_TIME
CALCULATED_ELAPSED_TIME
ENTERED_LABOR_TIME
ENTERED_MACHINE_TIME
USER_ELAPSED_TIME
NET_PLANNING_PERCENT
"_LA:COUNT_POINT_TYPE"
"_LA:BACKFLUSH_FLAG"
"_LA:OPTION_DEPENDENT_FLAG"
"_LA:REFERENCE_FLAG"
OPERATION_CODE
DEPARTMENT_CODE
ROUTING_SEQUENCE_ID
OPERATION_SEQUENCE_ID
STANDARD_OPERATION_ID
DEPARTMENT_ID
UPDATED_ON
UPDATED_BY
CREATED_ON
CREATED_BY