DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_ITEM_VENDOR_RELS_V

Line 7152: ahl_item_vendor_rels_v B

7148: l_msg_data VARCHAR2(2000);
7149: CURSOR verify_vendor(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
7150: SELECT A.inv_service_item_rel_id
7151: FROM ahl_inv_service_item_rels A,
7152: ahl_item_vendor_rels_v B
7153: WHERE A.inv_service_item_rel_id = B.inv_service_item_rel_id
7154: AND A.inv_item_id = p_osp_order_line_rec.inventory_item_id
7155: AND A.inv_org_id = p_osp_order_line_rec.inventory_org_id
7156: AND A.service_item_id = p_osp_order_line_rec.service_item_id