DBA Data[Home] [Help]

APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;

88: l_dummy_rowid VARCHAR2(18);
89: l_seq_num_profile VARCHAR2(80);
90:
91: l_hold_all_payments_flag ap_suppliers.hold_all_payments_flag%TYPE;
92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;
93: l_accounting_event_id NUMBER(38);
94: l_quick_check_id AP_CHECKS.checkrun_name%type;
95: l_next_check_number AP_CHECKS.check_number%type;
96: l_check_number AP_CHECKS.check_number%type;

Line 190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE

186: ,Address_Line2 HZ_LOCATIONS.Address2%TYPE
187: ,Address_Line3 HZ_LOCATIONS.Address3%TYPE
188: ,City HZ_LOCATIONS.City%TYPE
189: ,country HZ_LOCATIONS.Country%TYPE
190: ,Vendor_site_code AP_SUPPLIER_SITES_ALL.Vendor_Site_Code%TYPE
191: ,Zip HZ_LOCATIONS.Postal_Code%TYPE
192: ,Province HZ_LOCATIONS.Province%TYPE
193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE

Line 198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE

194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE
198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE
199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%TYPE
200: ,Primary_Pay_Site AP_SUPPLIER_SITES_ALL.Primary_Pay_Site_Flag%TYPE
201: );
202:

Line 199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%TYPE

195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE
198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE
199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%TYPE
200: ,Primary_Pay_Site AP_SUPPLIER_SITES_ALL.Primary_Pay_Site_Flag%TYPE
201: );
202:
203: TYPE r_vendor_info IS RECORD

Line 200: ,Primary_Pay_Site AP_SUPPLIER_SITES_ALL.Primary_Pay_Site_Flag%TYPE

196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE
198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE
199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%TYPE
200: ,Primary_Pay_Site AP_SUPPLIER_SITES_ALL.Primary_Pay_Site_Flag%TYPE
201: );
202:
203: TYPE r_vendor_info IS RECORD
204: (

Line 613: ap_supplier_sites_all assp

609: INTO l_hold_all_payments_flag,
610: l_active_pay_sites,
611: l_vendor_type_lookup_code
612: FROM ap_suppliers asup,
613: ap_supplier_sites_all assp
614: WHERE asup.vendor_id = l_inv_rec.vendor_id
615: AND asup.vendor_id = assp.vendor_id
616: AND assp.vendor_site_id = l_inv_rec.vendor_site_id;
617:

Line 659: FROM ap_supplier_sites_all asus,

655: l_apvs_rec.Vendor_Site_Id,
656: l_apvs_rec.Vendor_site_code,
657: l_apvs_rec.Pay_Site_Flag,
658: l_apvs_rec.Primary_Pay_Site
659: FROM ap_supplier_sites_all asus,
660: hz_locations hzl
661: WHERE asus.vendor_site_id = l_inv_rec.vendor_site_id
662: AND asus.location_id = hzl.location_id
663: AND nvl(trunc(asus.inactive_date),sysdate+1) > trunc(sysdate);

Line 705: FROM ap_supplier_sites_all asus,

701: l_apvs_rec.Vendor_Site_Id,
702: l_apvs_rec.Vendor_site_code,
703: l_apvs_rec.Pay_Site_Flag,
704: l_apvs_rec.Primary_Pay_Site
705: FROM ap_supplier_sites_all asus,
706: hz_locations hzl
707: WHERE asus.vendor_site_id = l_inv_rec.vendor_site_id
708: AND asus.location_id = hzl.location_id
709: AND nvl(trunc(asus.inactive_date),sysdate+1)

Line 752: FROM ap_supplier_sites_all asus,

748: l_apvs_rec.Vendor_Site_Id,
749: l_apvs_rec.Vendor_site_code,
750: l_apvs_rec.Pay_Site_Flag,
751: l_apvs_rec.Primary_Pay_Site
752: FROM ap_supplier_sites_all asus,
753: hz_locations hzl
754: WHERE asus.vendor_site_id = l_inv_rec.vendor_site_id
755: AND asus.location_id = hzl.location_id
756: AND nvl(trunc(asus.inactive_date),sysdate+1)