APPS.AHL_MC_ITEM_COMP_PUB dependencies on AHL_MTL_ITEMS_NON_OU_V

Line 33: FROM ahl_mtl_items_non_ou_v

29:
30: CURSOR mtl_system_items_csr(p_inventory_item_name IN VARCHAR2,
31: p_inv_organization_id IN NUMBER) IS
32: SELECT inventory_item_id
33: FROM ahl_mtl_items_non_ou_v
34: WHERE concatenated_segments = p_inventory_item_name
35: AND inventory_org_id = p_inv_organization_id;
36:
37: CURSOR mtl_segment_csr(p_inventory_item_id IN NUMBER,

Line 40: FROM ahl_mtl_items_non_ou_v

36:
37: CURSOR mtl_segment_csr(p_inventory_item_id IN NUMBER,
38: p_inv_organization_id IN NUMBER) IS
39: SELECT concatenated_segments
40: FROM ahl_mtl_items_non_ou_v
41: WHERE inventory_item_id = p_inventory_item_id
42: AND inventory_org_id = p_inv_organization_id;
43:
44: l_inv_org_id NUMBER;

Line 278: FROM ahl_mtl_items_non_ou_v

274: -- For inventory_item_id.
275: CURSOR mtl_system_items_csr(p_inventory_item_name IN VARCHAR2,
276: p_inv_organization_id IN NUMBER) IS
277: SELECT inventory_item_id
278: FROM ahl_mtl_items_non_ou_v
279: WHERE concatenated_segments = p_inventory_item_name
280: AND inventory_org_id = p_inv_organization_id;
281:
282: -- For concatenated segments.

Line 286: FROM ahl_mtl_items_non_ou_v

282: -- For concatenated segments.
283: CURSOR mtl_segment_csr(p_inventory_item_id IN NUMBER,
284: p_inv_organization_id IN NUMBER) IS
285: SELECT concatenated_segments
286: FROM ahl_mtl_items_non_ou_v
287: WHERE inventory_item_id = p_inventory_item_id
288: AND inventory_org_id = p_inv_organization_id;
289:
290: