VIEW: APPS.ENG_REVISED_ITEMS_INTERFACE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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