DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on PO_VENDOR_SITES_ALL

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

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

Line 424: FROM po_vendor_sites_all

420:
421:
422: CURSOR C_vendor_site_id IS
423: SELECT vendor_site_id
424: FROM po_vendor_sites_all
425: WHERE vendor_id = p_vendor_id
426: AND org_id = p_org_id /* Added for Bug 2839228 */
427: AND vendor_site_code = p_vendor_site_code ;
428:

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

565: disribution_line_number=1
566:
567: 8. 03/08/2004 Aparajita for bug#2839228. Version#115.2
568:
569: Modified cursor C_vendor_site_id to select vendor site id from po_vendor_sites_all
570: considering the operating unit also. This was needed as vendor site code for the
571: same vendor may be same accross operating units..
572:
573: 9. 05/11/2004 Sanjikum for bug # 3896940, Version 115.3

Line 897: FROM po_vendor_sites_all

893: ; Commented by nprashar for bug 8307469*/
894:
895: CURSOR C_vendor_site_id IS
896: SELECT vendor_site_id
897: FROM po_vendor_sites_all
898: WHERE vendor_id = p_vendor_id
899: AND org_id = p_org_id /* Added for Bug 2839228 */
900: AND vendor_site_code = p_vendor_site_code ;
901: