APPS.AHL_FMP_PVT dependencies on AHL_MR_EFFECTIVITIES_APP_V

Line 97: FROM ahl_mr_effectivities_app_v

93: --check whether the given mr_effecitivity_id exists
94: CURSOR check_mr_effect(c_mr_effectivity_id number ,c_mr_header_id number)
95: IS
96: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
97: FROM ahl_mr_effectivities_app_v
98: WHERE mr_effectivity_id = NVL(c_mr_effectivity_id,mr_effectivity_id)
99: AND mr_header_id = c_mr_header_id;
100: l_mr_effect check_mr_effect%ROWTYPE;
101:

Line 108: FROM ahl_mr_effectivities_app_v

104: --all the mr_effectivity_id's for the given MR).
105: CURSOR get_mr_effect(c_mr_header_id NUMBER, c_mr_effectivity_id NUMBER)
106: IS
107: SELECT mr_header_id, mr_effectivity_id, inventory_item_id,relationship_id, pc_node_id
108: FROM ahl_mr_effectivities_app_v
109: WHERE mr_header_id = c_mr_header_id
110: AND mr_effectivity_id = NVL(c_mr_effectivity_id, mr_effectivity_id);
111: --get distinct item instances from the global temporary table
112: CURSOR get_dist_inst

Line 2988: FROM ahl_mr_effectivities_app_v

2984: l_unique_mr_headers_tbl unique_mr_headers_tbl_type;
2985: */
2986: CURSOR get_applicable_mrs(c_inventory_item_id NUMBER) IS
2987: SELECT mr_header_id, mr_effectivity_id
2988: FROM ahl_mr_effectivities_app_v
2989: WHERE inventory_item_id = c_inventory_item_id
2990: ORDER BY mr_header_id, mr_effectivity_id;
2991:
2992: /*