Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BOMFV_ROUTING_REVISIONS |
SELECT RT.PROCESS_REVISION REVISION
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, RT.ECN_INITIATION_DATE ECO_INITIATION_DATE
, RT.IMPLEMENTATION_DATE IMPLEMENTATION_DATE
, RT.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, RT.CHANGE_NOTICE
, NULL
, '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME"
, 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 MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS 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