VIEW: APPS.BOMBV_ROUTING_REVISIONS

Source

View Text - Preformatted

SELECT RT.PROCESS_REVISION REVISION , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME ,'_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME" , RT.ECN_INITIATION_DATE ECO_INITIATION_DATE , RT.IMPLEMENTATION_DATE IMPLEMENTATION_DATE , RT.EFFECTIVITY_DATE START_EFFECTIVITY_DATE , RT.CHANGE_NOTICE , NULL , RT.ORGANIZATION_ID , RT.INVENTORY_ITEM_ID , RT.LAST_UPDATE_DATE UPDATED_ON , RT.LAST_UPDATED_BY UPDATED_BY , RT.CREATION_DATE CREATED_ON , RT.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL,MTL_PARAMETERS PA,MTL_SYSTEM_ITEMS_B SY,MTL_RTG_ITEM_REVISIONS RT WHERE RT.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RT.ORGANIZATION_ID = AL.ORGANIZATION_ID AND RT.ORGANIZATION_ID = SY.ORGANIZATION_ID AND RT.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND '_SEC:RT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT RT.PROCESS_REVISION REVISION
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME"
, RT.ECN_INITIATION_DATE ECO_INITIATION_DATE
, RT.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, RT.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, RT.CHANGE_NOTICE
, NULL
, RT.ORGANIZATION_ID
, RT.INVENTORY_ITEM_ID
, RT.LAST_UPDATE_DATE UPDATED_ON
, RT.LAST_UPDATED_BY UPDATED_BY
, RT.CREATION_DATE CREATED_ON
, RT.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS_B SY
, MTL_RTG_ITEM_REVISIONS RT
WHERE RT.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RT.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RT.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND RT.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND '_SEC:RT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY