APPS.AHL_DI_DOC_INDEX_PUB dependencies on PO_VENDORS

Line 94: -- Used to retrieve vendor id from po vendors

90: IS
91: SELECT party_id
92: FROM hz_parties
93: WHERE party_id = c_party_id;
94: -- Used to retrieve vendor id from po vendors
95: CURSOR for_vendor_id(c_segment1 IN VARCHAR2)
96: IS
97: SELECT vendor_id
98: FROM po_vendors

Line 98: FROM po_vendors

94: -- Used to retrieve vendor id from po vendors
95: CURSOR for_vendor_id(c_segment1 IN VARCHAR2)
96: IS
97: SELECT vendor_id
98: FROM po_vendors
99: WHERE segment1 = c_segment1;
100:
101: --Enhancement #2275357: pbarman 1st April 2003
102: --Cursor to retrieve operator code from hz parties

Line 1323: -- Used to retrieve vendor id from po vendors

1319: IS
1320: SELECT party_id
1321: FROM hz_parties
1322: WHERE party_id = c_party_id;
1323: -- Used to retrieve vendor id from po vendors
1324: CURSOR for_vendor_id(c_segment1 IN VARCHAR2)
1325: IS
1326: SELECT vendor_id
1327: FROM po_vendors

Line 1327: FROM po_vendors

1323: -- Used to retrieve vendor id from po vendors
1324: CURSOR for_vendor_id(c_segment1 IN VARCHAR2)
1325: IS
1326: SELECT vendor_id
1327: FROM po_vendors
1328: WHERE segment1 = c_segment1;
1329: --Added pjha for Restricting Subscription Avail to 'Yes' If supplier or subscription
1330: --Exists for the doc: Begin
1331: -- Cursor used to find if a supplier exist for the document

Line 1391: FROM PO_VENDORS

1387:
1388: CURSOR for_supplier_name_po(c_supplier_no NUMBER)
1389: IS
1390: SELECT DISTINCT VENDOR_NAME
1391: FROM PO_VENDORS
1392: WHERE SEGMENT1 =c_supplier_no;
1393:
1394: --
1395: