DBA Data[Home] [Help]

APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_ITEM_VENDOR_RELS

Line 1523: ahl_item_vendor_rels IV

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
1527: AND SI.service_item_id = c_service_item_id