DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on PO_VENDOR_SITES_ALL

Line 96: Modified cursor C_vendor_site_id to select vendor site id from po_vendor_sites_all

92: with disribution_line_number=1
93:
94: 8. 03/08/2004 Aparajita for bug#2839228. Version#115.2
95:
96: Modified cursor C_vendor_site_id to select vendor site id from po_vendor_sites_all
97: considering the operating unit also. This was needed as vendor site code for the
98: same vendor may be same accross operating units..
99:
100: 9. 05/11/2004 Sanjikum for bug # 3896940, Version 115.3

Line 403: FROM po_vendor_sites_all

399:
400:
401: CURSOR C_vendor_site_id IS
402: SELECT vendor_site_id
403: FROM po_vendor_sites_all
404: WHERE vendor_id = p_vendor_id
405: AND org_id = p_org_id /* Added for Bug 2839228 */
406: AND vendor_site_code = p_vendor_site_code ;
407:

Line 546: Modified cursor C_vendor_site_id to select vendor site id from po_vendor_sites_all

542: disribution_line_number=1
543:
544: 8. 03/08/2004 Aparajita for bug#2839228. Version#115.2
545:
546: Modified cursor C_vendor_site_id to select vendor site id from po_vendor_sites_all
547: considering the operating unit also. This was needed as vendor site code for the
548: same vendor may be same accross operating units..
549:
550: 9. 05/11/2004 Sanjikum for bug # 3896940, Version 115.3

Line 855: FROM po_vendor_sites_all

851: ;
852:
853: CURSOR C_vendor_site_id IS
854: SELECT vendor_site_id
855: FROM po_vendor_sites_all
856: WHERE vendor_id = p_vendor_id
857: AND org_id = p_org_id /* Added for Bug 2839228 */
858: AND vendor_site_code = p_vendor_site_code ;
859: