APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_INV_SERVICE_ITEM_RELS

Line 4593: FROM ahl_inv_service_item_rels SI,

4589: FROM ahl_osp_orders_b
4590: WHERE osp_order_id = p_x_osp_order_line_rec.osp_order_id;
4591: IF (l_vendor_id IS NOT NULL AND l_vendor_site_id IS NOT NULL) THEN
4592: SELECT IV.service_duration INTO l_service_duration
4593: FROM ahl_inv_service_item_rels SI,
4594: ahl_item_vendor_rels IV,
4595: ahl_vendor_certifications_v VC
4596: WHERE SI.inv_item_id = p_x_osp_order_line_rec.inventory_item_id
4597: AND SI.inv_org_id = p_x_osp_order_line_rec.inventory_org_id

Line 6033: FROM ahl_inv_service_item_rels SI,

6029: Also added the inv_org_id related OU filter */
6030:
6031: SELECT IV.vendor_certification_id,
6032: IV.rank
6033: FROM ahl_inv_service_item_rels SI,
6034: ahl_item_vendor_rels IV,
6035: ahl_vendor_certifications_v VC
6036: WHERE SI.inv_service_item_rel_id = IV.inv_service_item_rel_id
6037: AND IV.vendor_certification_id = VC.vendor_certification_id

Line 6193: FROM ahl_inv_service_item_rels isr,

6189:
6190: CURSOR is_vendor_defined_csr (c_inventory_item_id IN NUMBER,
6191: c_service_item_id IN NUMBER) IS
6192: SELECT 1
6193: FROM ahl_inv_service_item_rels isr,
6194: ahl_item_vendor_rels ivr
6195: WHERE isr.inv_item_id = c_inventory_item_id AND
6196: isr.service_item_id = c_service_item_id AND
6197: isr.inv_service_item_rel_id = ivr.inv_service_item_rel_id;

Line 7151: FROM ahl_inv_service_item_rels A,

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