VIEW: APPS.BOMFV_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.TOTAL_PRODUCT_CYCLE_TIME TOTAL_CYCLE_TIME , OP.PRIORITY ROUTING_PRIORITY , OP.ROUTING_COMMENT "COMMENT" , '_LA:OP.ROUTING_TYPE:MFG_LOOKUPS:BOM_NO_YES:MEANING' , '_LA:OP.MIXED_MODEL_MAP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:OP.CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:OP.CFM_ROUTING_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" , LI.LINE_CODE LINE_NAME , PR.NAME PROJECT_NAME , TA.TASK_NAME TASK_NAME , '_DF:BOM:BOM_OPERATIONAL_ROUTINGS:OP' , OP.ROUTING_SEQUENCE_ID , OP.ORGANIZATION_ID , OP.COMMON_ASSEMBLY_ITEM_ID , OP.ASSEMBLY_ITEM_ID , OP.COMMON_ROUTING_SEQUENCE_ID , OP.COMPLETION_SUBINVENTORY , OP.COMPLETION_LOCATOR_ID , OP.LINE_ID , OP.PROJECT_ID , OP.TASK_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, WIP_LINES LI, 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.LINE_ID = LI.LINE_ID(+) AND OP2.COMMON_ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+) AND OP2.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 '_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.TOTAL_PRODUCT_CYCLE_TIME TOTAL_CYCLE_TIME
, OP.PRIORITY ROUTING_PRIORITY
, OP.ROUTING_COMMENT "COMMENT"
, '_LA:OP.ROUTING_TYPE:MFG_LOOKUPS:BOM_NO_YES:MEANING'
, '_LA:OP.MIXED_MODEL_MAP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:OP.CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:OP.CFM_ROUTING_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"
, LI.LINE_CODE LINE_NAME
, PR.NAME PROJECT_NAME
, TA.TASK_NAME TASK_NAME
, '_DF:BOM:BOM_OPERATIONAL_ROUTINGS:OP'
, OP.ROUTING_SEQUENCE_ID
, OP.ORGANIZATION_ID
, OP.COMMON_ASSEMBLY_ITEM_ID
, OP.ASSEMBLY_ITEM_ID
, OP.COMMON_ROUTING_SEQUENCE_ID
, OP.COMPLETION_SUBINVENTORY
, OP.COMPLETION_LOCATOR_ID
, OP.LINE_ID
, OP.PROJECT_ID
, OP.TASK_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
, WIP_LINES LI
, 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.LINE_ID = LI.LINE_ID(+)
AND OP2.COMMON_ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND OP2.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 '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY