View: BOMFV_WORK_ORDER_RTG_OPRATNS

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

View Text

SELECT SQ.OPERATION_SEQ_NUM SEQUENCE_NUMBER
, SQ.EFFECTIVITY_DATE START_EFFECTIV_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: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'
, ST.OPERATION_CODE OPERATION_CODE
, DE.DEPARTMENT_CODE DEPARTMENT_CODE
, SQ.ROUTING_SEQUENCE_ID 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
, BOM_STANDARD_OPERATIONS ST
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_DEPARTMENTS DE
, BOM_OPERATION_SEQUENCES SQ
WHERE SQ.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND SQ.STANDARD_OPERATION_ID = ST.STANDARD_OPERATION_ID(+)
AND 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 IS NULL OR SQ.OPERATION_TYPE =1 )
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns