APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_INV_SERVICE_ITEM_RELS

Line 4943: FROM ahl_inv_service_item_rels SI,

4939: FROM ahl_osp_orders_b
4940: WHERE osp_order_id = p_x_osp_order_line_rec.osp_order_id;
4941: IF (l_vendor_id IS NOT NULL AND l_vendor_site_id IS NOT NULL) THEN
4942: SELECT IV.service_duration INTO l_service_duration
4943: FROM ahl_inv_service_item_rels SI,
4944: ahl_item_vendor_rels IV,
4945: ahl_vendor_certifications_v VC
4946: WHERE SI.inv_item_id = p_x_osp_order_line_rec.inventory_item_id
4947: AND SI.inv_org_id = p_x_osp_order_line_rec.inventory_org_id

Line 6482: FROM ahl_inv_service_item_rels SI,

6478: Also added the inv_org_id related OU filter */
6479:
6480: SELECT IV.vendor_certification_id,
6481: IV.rank
6482: FROM ahl_inv_service_item_rels SI,
6483: ahl_item_vendor_rels IV,
6484: ahl_vendor_certifications_v VC
6485: WHERE SI.inv_service_item_rel_id = IV.inv_service_item_rel_id
6486: AND IV.vendor_certification_id = VC.vendor_certification_id

Line 6642: FROM ahl_inv_service_item_rels isr,

6638:
6639: CURSOR is_vendor_defined_csr (c_inventory_item_id IN NUMBER,
6640: c_service_item_id IN NUMBER) IS
6641: SELECT 1
6642: FROM ahl_inv_service_item_rels isr,
6643: ahl_item_vendor_rels ivr
6644: WHERE isr.inv_item_id = c_inventory_item_id AND
6645: isr.service_item_id = c_service_item_id AND
6646: isr.inv_service_item_rel_id = ivr.inv_service_item_rel_id;

Line 7600: FROM ahl_inv_service_item_rels A,

7596: l_msg_count NUMBER;
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