VIEW: APPS.ENG_CHANGE_SUBJECTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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