APPS.AHL_FMP_PVT dependencies on AHL_MR_EFFECTIVITIES_APP_V

Line 137: FROM ahl_mr_effectivities_app_v

133: --check whether the given mr_effecitivity_id exists
134: CURSOR check_mr_effect(c_mr_effectivity_id number ,c_mr_header_id number)
135: IS
136: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
137: FROM ahl_mr_effectivities_app_v
138: WHERE mr_effectivity_id = NVL(c_mr_effectivity_id,mr_effectivity_id)
139: AND mr_header_id = c_mr_header_id;
140: l_mr_effect check_mr_effect%ROWTYPE;
141:

Line 148: FROM ahl_mr_effectivities_app_v

144: --all the mr_effectivity_id's for the given MR).
145: CURSOR get_mr_effect(c_mr_header_id NUMBER, c_mr_effectivity_id NUMBER)
146: IS
147: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
148: FROM ahl_mr_effectivities_app_v
149: WHERE mr_header_id = c_mr_header_id
150: AND mr_effectivity_id = NVL(c_mr_effectivity_id, mr_effectivity_id);
151: --get distinct item instances from the global temporary table
152: CURSOR get_dist_inst

Line 3907: FROM ahl_mr_effectivities_app_v

3903: */
3904: /* modified for performance fix - bug# 6511501
3905: CURSOR get_applicable_mrs(c_inventory_item_id NUMBER) IS
3906: SELECT mr_header_id, mr_effectivity_id
3907: FROM ahl_mr_effectivities_app_v
3908: WHERE inventory_item_id = c_inventory_item_id
3909: ORDER BY mr_header_id, mr_effectivity_id;
3910: */
3911: