APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_MR_EFFECTIVITIES

Line 220: FROM AHL_MR_EFFECTIVITIES_V

216: item_number,
217: position_item_number ),
218: relationship_id,
219: position_ref_meaning
220: FROM AHL_MR_EFFECTIVITIES_V
221: WHERE mr_effectivity_id = c_mr_effectivity_id;
222:
223: BEGIN
224: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 898: AHL_MR_EFFECTIVITIES EFF

894: Cursor find_min_max_serials ( c_mr_effectivity_id NUMBER )
895: IS
896: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
897: from csi_item_instances CSI,
898: AHL_MR_EFFECTIVITIES EFF
899: where
900: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
901: CSI.inventory_item_id = EFF.inventory_item_id
902: UNION

Line 906: AHL_MR_EFFECTIVITIES EFF

902: UNION
903: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
904: from csi_item_instances CSI,
905: ahl_position_alternates_v PA,
906: AHL_MR_EFFECTIVITIES EFF
907: where
908: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
909: EFF.RELATIONSHIP_ID = PA.relationship_id and
910: CSI.inventory_item_id = PA.inventory_item_id;