APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_VENDOR_CERTIFICATIONS_V

Line 606: FROM ahl_vendor_certifications_v

602: AND NVL(vendor_start_date_active, SYSDATE - 1) <= SYSDATE
603: AND NVL(vendor_end_date_active, SYSDATE + 1) > SYSDATE;
604: CURSOR get_vendor_cert IS
605: SELECT 'X'
606: FROM ahl_vendor_certifications_v
607: WHERE vendor_id = p_vendor_id
608: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
609: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
610: l_exist VARCHAR2(1);

Line 650: FROM ahl_vendor_certifications_v

646: AND purchasing_site_flag = G_YES_FLAG
647: AND NVL(RFQ_ONLY_SITE_FLAG, G_NO_FLAG) = G_NO_FLAG;
648: CURSOR get_vendor_cert IS
649: SELECT 'X'
650: FROM ahl_vendor_certifications_v
651: WHERE vendor_id = p_vendor_id
652: AND vendor_site_id = p_vendor_site_id
653: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
654: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);

Line 4945: ahl_vendor_certifications_v VC

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
4949: AND VC.vendor_id = l_vendor_id

Line 6484: ahl_vendor_certifications_v VC

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
6488: AND SI.inv_org_id = c_inv_org_id

Line 6501: FROM ahl_vendor_certifications_v

6497: CURSOR get_vendor_ids(c_vendor_cert_id NUMBER) IS
6498: SELECT vendor_id,
6499: vendor_site_id,
6500: vendor_contact_id
6501: FROM ahl_vendor_certifications_v
6502: WHERE vendor_certification_id = c_vendor_cert_id
6503: AND trunc(active_start_date) <= trunc(SYSDATE)
6504: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
6505: TYPE vendor_rank_count_rec_type IS RECORD (

Line 6727: FROM ahl_vendor_certifications_v

6723: AND TRUNC(NVL(vendor_start_date_active, SYSDATE - 1)) <= TRUNC(SYSDATE)
6724: AND TRUNC(NVL(vendor_end_date_active, SYSDATE + 1)) > TRUNC(SYSDATE);
6725: CURSOR get_vendor_cert IS
6726: SELECT 'X'
6727: FROM ahl_vendor_certifications_v
6728: WHERE vendor_id = p_vendor_id
6729: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
6730: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
6731: CURSOR val_vendor_site_id_csr IS

Line 6741: FROM ahl_vendor_certifications_v

6737: AND purchasing_site_flag = G_YES_FLAG
6738: AND NVL(RFQ_ONLY_SITE_FLAG, G_NO_FLAG) =G_NO_FLAG ;
6739: CURSOR get_site_cert IS
6740: SELECT 'X'
6741: FROM ahl_vendor_certifications_v
6742: WHERE vendor_id = p_vendor_id
6743: AND vendor_site_id = p_vendor_site_id
6744: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
6745: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);

Line 7671: FROM ahl_vendor_certifications_v

7667: --validate it against OSP header vendor attributes
7668: --Check the vendor itself is valid
7669: BEGIN
7670: SELECT 'X' INTO g_dummy_char
7671: FROM ahl_vendor_certifications_v
7672: WHERE vendor_id = l_vendor_id
7673: AND vendor_site_id = l_vendor_site_id
7674: AND trunc(active_start_date) <= trunc(SYSDATE)
7675: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);