[Home] [Help]
View: MTL_ITEM_REV_HIGHDATE_V
View Text
SELECT REV1.ORGANIZATION_ID
, REV1.INVENTORY_ITEM_ID
, REV1.REVISION_ID
, REV1.REVISION
, REV1.EFFECTIVITY_DATE
, NVL(MIN(REV2.EFFECTIVITY_DATE - 1/(60*60*24))
, GREATEST(SYSDATE
, REV1.EFFECTIVITY_DATE))
, REV1.IMPLEMENTATION_DATE
, REV1.CHANGE_NOTICE
FROM MTL_ITEM_REVISIONS_B REV2
, MTL_ITEM_REVISIONS_B REV1
WHERE REV1.ORGANIZATION_ID = REV2.ORGANIZATION_ID(+)
AND REV1.INVENTORY_ITEM_ID = REV2.INVENTORY_ITEM_ID(+)
AND REV2.EFFECTIVITY_DATE(+) > REV1.EFFECTIVITY_DATE GROUP BY REV1.ORGANIZATION_ID
, REV1.INVENTORY_ITEM_ID
, REV1.REVISION_ID
, REV1.REVISION
, REV1.EFFECTIVITY_DATE
, REV1.IMPLEMENTATION_DATE
, REV1.CHANGE_NOTICE
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
REVISION_ID |
REVISION |
EFFECTIVITY_DATE |
HIGH_DATE |
IMPLEMENTATION_DATE |
CHANGE_NOTICE |