VIEW: APPS.ENG_REVISED_ITEMS_API_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'