DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_ITEM_VENDOR_RELS_V

Line 7601: ahl_item_vendor_rels_v B

7597: l_msg_data VARCHAR2(2000);
7598: CURSOR verify_vendor(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
7599: SELECT A.inv_service_item_rel_id
7600: FROM ahl_inv_service_item_rels A,
7601: ahl_item_vendor_rels_v B
7602: WHERE A.inv_service_item_rel_id = B.inv_service_item_rel_id
7603: AND A.inv_item_id = p_osp_order_line_rec.inventory_item_id
7604: AND A.inv_org_id = p_osp_order_line_rec.inventory_org_id
7605: AND A.service_item_id = p_osp_order_line_rec.service_item_id