View: ENG_IMPACTED_BILLS_ERV

Product:	ENG - Engineering
Description:
Implementation/DBA Data:	APPS.ENG_IMPACTED_BILLS_ERV

View Text

SELECT MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, ERI.ALTERNATE_BOM_DESIGNATOR
, MIR.REVISION
, MIC.CATEGORY_SET_NAME
, MIC.SEGMENT1||'.'||MIC.SEGMENT2
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS_VL MSI
, MTL_ITEM_REVISIONS MIR
, ENG_REVISED_ITEMS_V ERI
, MTL_ITEM_CATEGORIES_V MIC
WHERE MSI.ORGANIZATION_ID = MIR.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = ERI.ORGANIZATION_ID
AND ERI.REVISED_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID

Columns