VIEW: APPS.BOMFV_WORK_ORDER_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" , OP.PRIORITY ROUTING_PRIORITY , OP.ROUTING_COMMENT "COMMENT" , '_LA:OP.ROUTING_TYPE:MFG_LOOKUPS:BOM_NO_YES:MEANING' , '_LA:OP.CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , OP2.ALTERNATE_ROUTING_DESIGNATOR COMMON_ALTERNATE_ROUTING_CODE , '_KF:INV:MSTK:SY2' "_KF:COMMON_ROUTING_NAME" , '_KF:INV:MTLL:LO' "_KF:COMPLETION_LOCATOR_CODE" , PR.NAME PROJECT_NAME , TA.TASK_NAME TASK_NAME , '_DF:BOM:BOM_OPERATIONAL_ROUTINGS:OP' , OP.ROUTING_SEQUENCE_ID , OP.ORGANIZATION_ID , OP.PROJECT_ID , OP.TASK_ID , OP.COMMON_ASSEMBLY_ITEM_ID , OP.ASSEMBLY_ITEM_ID , OP.COMMON_ROUTING_SEQUENCE_ID , OP.COMPLETION_SUBINVENTORY , OP.COMPLETION_LOCATOR_ID , OP.CREATED_BY , OP.CREATION_DATE CREATED_ON , OP.LAST_UPDATE_DATE UPDATED_ON , OP.LAST_UPDATED_BY UPDATED_BY FROM MTL_SYSTEM_ITEMS SY, MTL_PARAMETERS PA, MTL_SYSTEM_ITEMS SY2, BOM_OPERATIONAL_ROUTINGS OP2, MTL_ITEM_LOCATIONS LO, HR_ALL_ORGANIZATION_UNITS AL, PA_PROJECTS_ALL PR, PA_TASKS TA, BOM_OPERATIONAL_ROUTINGS OP WHERE OP.ORGANIZATION_ID = SY.ORGANIZATION_ID AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID AND OP.COMMON_ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+) AND OP.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+) AND OP.COMMON_ROUTING_SEQUENCE_ID = OP2.ROUTING_SEQUENCE_ID(+) AND OP.COMPLETION_LOCATOR_ID = LO.INVENTORY_LOCATION_ID(+) AND OP.ORGANIZATION_ID = LO.ORGANIZATION_ID (+) AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID AND OP.PROJECT_ID = PR.PROJECT_ID(+) AND OP.TASK_ID = TA.TASK_ID (+) AND ( OP.CFM_ROUTING_FLAG IS NULL OR OP.CFM_ROUTING_FLAG = 2 ) 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"
, OP.PRIORITY ROUTING_PRIORITY
, OP.ROUTING_COMMENT "COMMENT"
, '_LA:OP.ROUTING_TYPE:MFG_LOOKUPS:BOM_NO_YES:MEANING'
, '_LA:OP.CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, OP2.ALTERNATE_ROUTING_DESIGNATOR COMMON_ALTERNATE_ROUTING_CODE
, '_KF:INV:MSTK:SY2' "_KF:COMMON_ROUTING_NAME"
, '_KF:INV:MTLL:LO' "_KF:COMPLETION_LOCATOR_CODE"
, PR.NAME PROJECT_NAME
, TA.TASK_NAME TASK_NAME
, '_DF:BOM:BOM_OPERATIONAL_ROUTINGS:OP'
, OP.ROUTING_SEQUENCE_ID
, OP.ORGANIZATION_ID
, OP.PROJECT_ID
, OP.TASK_ID
, OP.COMMON_ASSEMBLY_ITEM_ID
, OP.ASSEMBLY_ITEM_ID
, OP.COMMON_ROUTING_SEQUENCE_ID
, OP.COMPLETION_SUBINVENTORY
, OP.COMPLETION_LOCATOR_ID
, OP.CREATED_BY
, OP.CREATION_DATE CREATED_ON
, OP.LAST_UPDATE_DATE UPDATED_ON
, OP.LAST_UPDATED_BY UPDATED_BY
FROM MTL_SYSTEM_ITEMS SY
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY2
, BOM_OPERATIONAL_ROUTINGS OP2
, MTL_ITEM_LOCATIONS LO
, HR_ALL_ORGANIZATION_UNITS AL
, PA_PROJECTS_ALL PR
, PA_TASKS TA
, BOM_OPERATIONAL_ROUTINGS OP
WHERE OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OP.COMMON_ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND OP.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND OP.COMMON_ROUTING_SEQUENCE_ID = OP2.ROUTING_SEQUENCE_ID(+)
AND OP.COMPLETION_LOCATOR_ID = LO.INVENTORY_LOCATION_ID(+)
AND OP.ORGANIZATION_ID = LO.ORGANIZATION_ID (+)
AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.PROJECT_ID = PR.PROJECT_ID(+)
AND OP.TASK_ID = TA.TASK_ID (+)
AND ( OP.CFM_ROUTING_FLAG IS NULL OR OP.CFM_ROUTING_FLAG = 2 )
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY