[Home] [Help]
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
4948: AND SI.service_item_id = p_x_osp_order_line_rec.service_item_id
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
6487: AND SI.inv_item_id = c_inv_item_id
6522: l_temp_vendor_index NUMBER := 0;
6523: l_dummy_contact_id NUMBER;
6524: BEGIN
6525: --This whole logic depends on the assumption that rank is mandatory in table
6526: --ahl_item_vendor_rels
6527: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
6529: G_LOG_PREFIX || 'derive_default_vendor',
6530: 'Procedure begins and count='||p_item_service_rels_tbl.count);
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;
6647:
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