Product: | EGO - Advanced Product Catalog |
---|---|
Description: | View for minor revisons information for any object. |
Implementation/DBA Data: | APPS.EGO_ITEM_MINOR_REVISIONS_V |
SELECT ROWNUM MINOR_REVISION_NUMBER
, EMR.MINOR_REVISION_ID
, EMR.MINOR_REVISION
, EMR.DESCRIPTION
, EMR.LAST_UPDATE_DATE
, EMR.LAST_UPDATED_BY
, EMR.CREATION_DATE
, EMR.CREATED_BY
, EMR.LAST_UPDATE_LOGIN
, EMR.OBJ_NAME
, MIR.INVENTORY_ITEM_ID
, MIR.ORGANIZATION_ID
, MIR.REVISION_ID
, MIR.REVISION
, MIR.EFFECTIVITY_DATE
, EMR.ATTRIBUTE_CATEGORY
, EMR.ATTRIBUTE1
, EMR.ATTRIBUTE2
, EMR.ATTRIBUTE3
, EMR.ATTRIBUTE4
, EMR.ATTRIBUTE5
, EMR.ATTRIBUTE6
, EMR.ATTRIBUTE7
, EMR.ATTRIBUTE8
, EMR.ATTRIBUTE9
, EMR.ATTRIBUTE10
, EMR.ATTRIBUTE12
, EMR.ATTRIBUTE11
, EMR.ATTRIBUTE13
, EMR.ATTRIBUTE14
, EMR.ATTRIBUTE15
, CONCAT(TO_CHAR(MIR.EFFECTIVITY_DATE
, 'YYYYMMDDHH24MISS')
, TO_CHAR(EMR.MINOR_REVISION_ID)) MINOR_REVISION_CODE
FROM EGO_MINOR_REVISIONS EMR
, MTL_ITEM_REVISIONS_B MIR
WHERE EMR.OBJ_NAME = 'EGO_ITEM_REVISION'
AND EMR.PK1_VALUE = MIR.INVENTORY_ITEM_ID
AND EMR.PK2_VALUE = MIR.ORGANIZATION_ID
AND EMR.PK3_VALUE = MIR.REVISION_ID UNION ALL SELECT 0 MINOR_REVISION_NUMBER
, EMR.MINOR_REVISION_ID
, EMR.MINOR_REVISION
, EMR.DESCRIPTION
, EMR.LAST_UPDATE_DATE
, EMR.LAST_UPDATED_BY
, EMR.CREATION_DATE
, EMR.CREATED_BY
, EMR.LAST_UPDATE_LOGIN
, 'EGO_ITEM_REVISION' "OBJ_NAME"
, MIR.INVENTORY_ITEM_ID
, MIR.ORGANIZATION_ID
, MIR.REVISION_ID
, MIR.REVISION
, MIR.EFFECTIVITY_DATE
, EMR.ATTRIBUTE_CATEGORY
, EMR.ATTRIBUTE1
, EMR.ATTRIBUTE2
, EMR.ATTRIBUTE3
, EMR.ATTRIBUTE4
, EMR.ATTRIBUTE5
, EMR.ATTRIBUTE6
, EMR.ATTRIBUTE7
, EMR.ATTRIBUTE8
, EMR.ATTRIBUTE9
, EMR.ATTRIBUTE10
, EMR.ATTRIBUTE12
, EMR.ATTRIBUTE11
, EMR.ATTRIBUTE13
, EMR.ATTRIBUTE14
, EMR.ATTRIBUTE15
, CONCAT(TO_CHAR(MIR.EFFECTIVITY_DATE
, 'YYYYMMDDHH24MISS')
, TO_CHAR(EMR.MINOR_REVISION_ID)) MINOR_REVISION_CODE
FROM EGO_MINOR_REVISIONS EMR
, MTL_ITEM_REVISIONS_B MIR
WHERE EMR.MINOR_REVISION_ID = 0