eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EGO_ITEM_MINOR_REVISIONS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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