DBA Data[Home] [Help]

APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_INV_SERVICE_ITEM_RELS

Line 1522: FROM ahl_inv_service_item_rels SI,

1518:
1519: CURSOR get_vendor_certs(c_inv_item_id NUMBER, c_inv_org_id NUMBER, c_service_item_id NUMBER) IS
1520: SELECT IV.vendor_certification_id,
1521: IV.rank
1522: FROM ahl_inv_service_item_rels SI,
1523: ahl_item_vendor_rels IV
1524: WHERE SI.inv_service_item_rel_id = IV.inv_service_item_rel_id
1525: AND SI.inv_item_id = c_inv_item_id
1526: AND SI.inv_org_id = c_inv_org_id