Product: | INV - Inventory |
---|---|
Description: | |
Implementation/DBA Data: | APPS.INVFV_ORG_ITEM_REVISIONS |
SELECT AL.NAME
, PA.ORGANIZATION_CODE
, '_KF:INV:MSTK:SY'
, IT.REVISION
, IT.CHANGE_NOTICE
, IT.ECN_INITIATION_DATE
, IT.IMPLEMENTATION_DATE
, IT.EFFECTIVITY_DATE
, '_DF:INV:MTL_ITEM_REVISIONS:IT'
, IT.INVENTORY_ITEM_ID
, IT.ORGANIZATION_ID
, IT.LAST_UPDATE_DATE
, IT.LAST_UPDATED_BY
, IT.CREATION_DATE
, IT.CREATED_BY
FROM MTL_SYSTEM_ITEMS SY
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_ITEM_REVISIONS IT
WHERE IT.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND IT.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND IT.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:IT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY