View: ENG_CHANGE_SUBJECTS_V

Product:	ENG - Engineering
Description:
Implementation/DBA Data:	APPS.ENG_CHANGE_SUBJECTS_V

View Text

SELECT ERI.CHANGE_ID
, -1 CHANGE_LINE_ID
, ERI.CREATED_BY
, ERI.CREATION_DATE
, ERI.LAST_UPDATED_BY
, ERI.LAST_UPDATE_DATE
, 'EGO_ITEM'
, TO_CHAR(ERI.REVISED_ITEM_ID)
, TO_CHAR(ERI.ORGANIZATION_ID)
, NULL PK3_VALUE
, NULL PK4_VALUE
, NULL PK5_VALUE
, 'EGO_ITEM'
, 1 SUBJECT_LEVEL
FROM ENG_REVISED_ITEMS ERI UNION SELECT ERI.CHANGE_ID
, -1 CHANGE_LINE_ID
, ERI.CREATED_BY
, ERI.CREATION_DATE
, ERI.LAST_UPDATED_BY
, ERI.LAST_UPDATE_DATE
, 'EGO_ITEM_REVISION'
, TO_CHAR(ERI.REVISED_ITEM_ID)
, TO_CHAR(ERI.ORGANIZATION_ID)
, TO_CHAR(MSIR.REVISION_ID)
, NULL PK4_VALUE
, NULL PK5_VALUE
, 'EGO_ITEM_REVISION'
, 1 SUBJECT_LEVEL
FROM ENG_REVISED_ITEMS ERI
, MTL_ITEM_REVISIONS_B MSIR
WHERE ERI.NEW_ITEM_REVISION IS NOT NULL
AND ERI.NEW_ITEM_REVISION = MSIR.REVISION
AND ERI.REVISED_ITEM_ID = MSIR.INVENTORY_ITEM_ID
AND ERI.ORGANIZATION_ID = MSIR.ORGANIZATION_ID UNION SELECT ECL.CHANGE_ID
, ECL.CHANGE_LINE_ID
, ECL.CREATED_BY
, ECL.CREATION_DATE
, ECL.LAST_UPDATED_BY
, ECL.LAST_UPDATE_DATE
, ECL.ENTITY_NAME
, ECL.PK1_VALUE
, ECL.PK2_VALUE
, ECL.PK3_VALUE
, ECL.PK4_VALUE
, ECL.PK5_VALUE
, ECL.ENTITY_NAME
, ECL.SUBJECT_LEVEL
FROM ENG_CHANGE_SUBJECTS ECL

Columns