VIEW: APPS.BOMFV_MFG_OPERATIONS

Source

View Text - Preformatted

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' , '_LA:SQ.OPERATION_TYPE: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 , RT.ORGANIZATION_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, BOM_DEPARTMENTS DE, MTL_SYSTEM_ITEMS SY, 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 SQ.ROUTING_SEQUENCE_ID = RT.COMMON_ROUTING_SEQUENCE_ID AND '_SEC:RT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

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'
, '_LA:SQ.OPERATION_TYPE: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
, RT.ORGANIZATION_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
, BOM_DEPARTMENTS DE
, MTL_SYSTEM_ITEMS SY
, 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 SQ.ROUTING_SEQUENCE_ID = RT.COMMON_ROUTING_SEQUENCE_ID
AND '_SEC:RT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY