Product: | ENG - Engineering |
---|---|
Description: | Mass change details |
Implementation/DBA Data: | APPS.ENG_REVISED_ITEMS_INTERFACE_V |
SELECT ERII.ROWID ROW_ID
, ERII.CHANGE_NOTICE
, ERII.ORGANIZATION_ID
, ERII.LAST_UPDATE_DATE
, ERII.LAST_UPDATED_BY
, ERII.CREATION_DATE
, ERII.CREATED_BY
, ERII.LAST_UPDATE_LOGIN
, ERII.SCHEDULED_DATE
, ERII.MRP_ACTIVE
, ERII.UPDATE_WIP
, ERII.USE_UP
, ERII.USE_UP_ITEM_ID
, ERII.REVISED_ITEM_SEQUENCE_ID
, ERII.ALTERNATE_BOM_DESIGNATOR
, ERII.CATEGORY_SET_ID
, ERII.STRUCTURE_ID
, ERII.ITEM_FROM
, ERII.ITEM_TO
, ERII.CATEGORY_FROM
, ERII.CATEGORY_TO
, ERII.DDF_CONTEXT
, ERII.INCREMENT_REV
, ERII.ITEM_TYPE
, ERII.USE_UP_PLAN_NAME
, ERII.ALTERNATE_SELECTION_CODE
, ERII.BASE_ITEM_ID
, MSI1.CONCATENATED_SEGMENTS
, MSI1.DESCRIPTION BASE_DESCRIPTION
, MSI2.CONCATENATED_SEGMENTS USE_UP_ITEM_NO
, MSI2.DESCRIPTION USE_UP_ITEM_DESCRIPTION
, MCS.CATEGORY_SET_NAME
, FCL.MEANING ITEM_TYPE_NAME
, ERII.FROM_END_ITEM_UNIT_NUMBER
FROM ENG_REVISED_ITEMS_INTERFACE ERII
, MTL_SYSTEM_ITEMS_VL MSI1
, MTL_SYSTEM_ITEMS_VL MSI2
, MTL_CATEGORY_SETS MCS
, FND_COMMON_LOOKUPS FCL
WHERE ERII.BASE_ITEM_ID = MSI1.INVENTORY_ITEM_ID(+)
AND ERII.ORGANIZATION_ID = MSI1.ORGANIZATION_ID(+)
AND ERII.USE_UP_ITEM_ID = MSI2.INVENTORY_ITEM_ID(+)
AND ERII.ORGANIZATION_ID = MSI2.ORGANIZATION_ID(+)
AND ERII.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID(+)
AND ERII.ITEM_TYPE = FCL.LOOKUP_CODE(+)
AND FCL.LOOKUP_TYPE(+) = 'ITEM_TYPE'
AND FCL.APPLICATION_ID(+) = 401