View: AHL_MR_ITEMS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on join of AHL_MR_EFFECTIVTIES_B, AHL_POSITION_ALTERNATES_V & MTL_SYSTEM_ITEMS_KFV to get the affected items for all maintenance requirements.
Implementation/DBA Data:	APPS.AHL_MR_ITEMS_V

View Text

SELECT DISTINCT EF.MR_HEADER_ID
, EF.MR_EFFECTIVITY_ID
, MTL.INVENTORY_ITEM_ID
, MTL.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_KFV MTL
, AHL_POSITION_ALTERNATES_V PA
, AHL_MR_EFFECTIVITIES_APP_V EF
WHERE MTL.INVENTORY_ITEM_ID = PA.INVENTORY_ITEM_ID
AND PA.RELATIONSHIP_ID = EF.RELATIONSHIP_ID
AND EF.RELATIONSHIP_ID IS NOT NULL
AND EF.INVENTORY_ITEM_ID IS NULL UNION SELECT DISTINCT EF.MR_HEADER_ID
, EF.MR_EFFECTIVITY_ID
, EF.INVENTORY_ITEM_ID
, MTL.CONCATENATED_SEGMENTS
FROM MTL_SYSTEM_ITEMS_KFV MTL
, AHL_MR_EFFECTIVITIES_APP_V EF
WHERE MTL.INVENTORY_ITEM_ID = EF.INVENTORY_ITEM_ID
AND EF.INVENTORY_ITEM_ID IS NOT NULL

Columns