[Home] [Help]
View: 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
CHANGE_NOTICE |
ORGANIZATION_ID |
REVISED_ITEM_ID |
REVISED_ITEM |
REVISED_ITEM_DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
IMPLEMENTATION_DATE |
DESCRIPTIVE_TEXT |
CANCELLATION_DATE |
CANCEL_COMMENTS |
DISPOSITION_TYPE |
DISPOSITION |
NEW_ITEM_REVISION |
AUTO_IMPLEMENT_DATE |
EARLY_SCHEDULE_DATE |
STATUS_TYPE |
REVISED_ITEM_STATUS |
SCHEDULED_DATE |
BILL_SEQUENCE_ID |
ALTERNATE_BOM_DESIGNATOR |
ASSEMBLY_TYPE |
MRP_ACTIVE |
UPDATE_WIP |
USE_UP |
USE_UP_ITEM_ID |
USE_UP_ITEM |
USE_UP_ITEM_DESCRIPTION |
REVISED_ITEM_SEQUENCE_ID |
USE_UP_PLAN_NAME |
ATTRIBUTE_CATEGORY |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
Name |