Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BOMFV_BOM_REVISIONS |
SELECT RV.REVISION ITEM_REVISION
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, RV.ECN_INITIATION_DATE ECO_INITIATION_DATE
, RV.IMPLEMENTATION_DATE ECO_IMPLEMENTATION_DATE
, RV.EFFECTIVITY_DATE START_EFFECTIVITY_DATE
, RV.DESCRIPTION DESCRIPTION
, RV.CHANGE_NOTICE
, NULL
, '_KF:INV:MSTK:SY1' "_KF:ITEM NAME"
, '_KF:INV:MSTK:SY2' "_KF:ECO REVISED ITEM NAME"
, RV.INVENTORY_ITEM_ID
, RV.ORGANIZATION_ID
, RV.REVISED_ITEM_SEQUENCE_ID
, RV.LAST_UPDATE_DATE UPDATED_ON
, RV.LAST_UPDATED_BY UPDATED_BY
, RV.CREATION_DATE CREATED_ON
, RV.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS_B SY1
, ENG_REVISED_ITEMS RI
, MTL_SYSTEM_ITEMS_B SY2
, MTL_PARAMETERS PA
, MTL_ITEM_REVISIONS_B RV
WHERE RI.REVISED_ITEM_ID = SY2.INVENTORY_ITEM_ID (+)
AND RI.ORGANIZATION_ID = SY2.ORGANIZATION_ID (+)
AND RV.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID (+)
AND RV.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RV.INVENTORY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND RV.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND RV.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:RV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY