APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 322: FROM AHL_MR_EFFECTIVITIES_V

318: item_number,
319: position_item_number ),
320: relationship_id,
321: position_ref_meaning
322: FROM AHL_MR_EFFECTIVITIES_V
323: WHERE mr_effectivity_id = c_mr_effectivity_id;
324:
325: BEGIN
326: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 443: FROM AHL_MR_EFFECTIVITIES_V

439: item_number,
440: position_item_number ),
441: relationship_id,
442: position_ref_meaning
443: FROM AHL_MR_EFFECTIVITIES_V
444: WHERE mr_effectivity_id = c_mr_effectivity_id;
445:
446: BEGIN
447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1742: AHL_MR_EFFECTIVITIES EFF

1738: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )
1739: IS
1740: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
1741: from csi_item_instances CSI,
1742: AHL_MR_EFFECTIVITIES EFF
1743: where
1744: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
1745: CSI.inventory_item_id = EFF.inventory_item_id
1746: UNION

Line 1750: AHL_MR_EFFECTIVITIES EFF

1746: UNION
1747: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
1748: from csi_item_instances CSI,
1749: ahl_position_alternates_v PA,
1750: AHL_MR_EFFECTIVITIES EFF
1751: where
1752: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
1753: EFF.RELATIONSHIP_ID = PA.relationship_id and
1754: CSI.inventory_item_id = PA.inventory_item_id;