View: ENG_REVISED_ITEMS_API_V

Product:	ENG - Engineering
Description:	Pending and implemented revised items
Implementation/DBA Data:	APPS.ENG_REVISED_ITEMS_API_V

View Text

SELECT ERI.CHANGE_NOTICE
, ERI.ORGANIZATION_ID
, ERI.REVISED_ITEM_ID
, MIF1.ITEM_NUMBER REVISED_ITEM
, MIF1.DESCRIPTION REVISED_ITEM_DESCRIPTION
, ERI.LAST_UPDATE_DATE
, ERI.LAST_UPDATED_BY
, ERI.CREATION_DATE
, ERI.CREATED_BY
, ERI.LAST_UPDATE_LOGIN
, ERI.IMPLEMENTATION_DATE
, ERI.DESCRIPTIVE_TEXT
, ERI.CANCELLATION_DATE
, ERI.CANCEL_COMMENTS
, ERI.DISPOSITION_TYPE
, ML2.MEANING DISPOSITION
, ERI.NEW_ITEM_REVISION
, ERI.AUTO_IMPLEMENT_DATE
, ERI.EARLY_SCHEDULE_DATE
, ERI.STATUS_TYPE
, ML1.MEANING REVISED_ITEM_STATUS
, ERI.SCHEDULED_DATE
, ERI.BILL_SEQUENCE_ID
, BOM.ALTERNATE_BOM_DESIGNATOR
, BOM.ASSEMBLY_TYPE
, ERI.MRP_ACTIVE
, ERI.UPDATE_WIP
, ERI.USE_UP
, ERI.USE_UP_ITEM_ID
, MIF2.ITEM_NUMBER USE_UP_ITEM
, MIF2.DESCRIPTION USE_UP_ITEM_DESCRIPTION
, ERI.REVISED_ITEM_SEQUENCE_ID
, ERI.USE_UP_PLAN_NAME
, ERI.ATTRIBUTE_CATEGORY
, ERI.ATTRIBUTE1
, ERI.ATTRIBUTE2
, ERI.ATTRIBUTE3
, ERI.ATTRIBUTE4
, ERI.ATTRIBUTE5
, ERI.ATTRIBUTE6
, ERI.ATTRIBUTE7
, ERI.ATTRIBUTE8
, ERI.ATTRIBUTE9
, ERI.ATTRIBUTE10
, ERI.ATTRIBUTE11
, ERI.ATTRIBUTE12
, ERI.ATTRIBUTE13
, ERI.ATTRIBUTE14
, ERI.ATTRIBUTE15
, ERI.REQUEST_ID
, ERI.PROGRAM_APPLICATION_ID
, ERI.PROGRAM_ID
, ERI.PROGRAM_UPDATE_DATE
FROM MTL_ITEM_FLEXFIELDS MIF2
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, BOM_BILL_OF_MATERIALS BOM
, MTL_ITEM_FLEXFIELDS MIF1
, ENG_REVISED_ITEMS ERI
WHERE ERI.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID (+)
AND ERI.ORGANIZATION_ID = MIF1.ORGANIZATION_ID
AND ERI.REVISED_ITEM_ID = MIF1.INVENTORY_ITEM_ID
AND ERI.ORGANIZATION_ID = MIF2.ORGANIZATION_ID (+)
AND ERI.USE_UP_ITEM_ID = MIF2.INVENTORY_ITEM_ID (+)
AND ERI.STATUS_TYPE = ML1.LOOKUP_CODE
AND ML1.LOOKUP_TYPE = 'ECG_ECN_STATUS'
AND ERI.DISPOSITION_TYPE = ML2.LOOKUP_CODE
AND ML2.LOOKUP_TYPE = 'ECG_MATERIAL_DISPOSITION'

Columns