eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on AP_INVOICES_ALL

Line 212: Vendor_id AP_INVOICES_ALL.vendor_id%TYPE

208:
209:
210: TYPE r_apinv_info IS RECORD
211: (
212: Vendor_id AP_INVOICES_ALL.vendor_id%TYPE
213: ,Vendor_Site_id AP_INVOICES_ALL.vendor_site_id%TYPE
214: ,Party_Id AP_INVOICES_ALL.party_id%TYPE
215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE
216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE

Line 213: ,Vendor_Site_id AP_INVOICES_ALL.vendor_site_id%TYPE

209:
210: TYPE r_apinv_info IS RECORD
211: (
212: Vendor_id AP_INVOICES_ALL.vendor_id%TYPE
213: ,Vendor_Site_id AP_INVOICES_ALL.vendor_site_id%TYPE
214: ,Party_Id AP_INVOICES_ALL.party_id%TYPE
215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE
216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE
217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE

Line 214: ,Party_Id AP_INVOICES_ALL.party_id%TYPE

210: TYPE r_apinv_info IS RECORD
211: (
212: Vendor_id AP_INVOICES_ALL.vendor_id%TYPE
213: ,Vendor_Site_id AP_INVOICES_ALL.vendor_site_id%TYPE
214: ,Party_Id AP_INVOICES_ALL.party_id%TYPE
215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE
216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE
217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE
218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE

Line 215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE

211: (
212: Vendor_id AP_INVOICES_ALL.vendor_id%TYPE
213: ,Vendor_Site_id AP_INVOICES_ALL.vendor_site_id%TYPE
214: ,Party_Id AP_INVOICES_ALL.party_id%TYPE
215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE
216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE
217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE
218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE
219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE

Line 217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE

213: ,Vendor_Site_id AP_INVOICES_ALL.vendor_site_id%TYPE
214: ,Party_Id AP_INVOICES_ALL.party_id%TYPE
215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE
216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE
217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE
218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE
219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE
220: ,Org_id AP_INVOICES_ALL.org_id%TYPE
221: ,Payment_Function AP_INVOICES_ALL.payment_function%TYPE

Line 218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE

214: ,Party_Id AP_INVOICES_ALL.party_id%TYPE
215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE
216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE
217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE
218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE
219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE
220: ,Org_id AP_INVOICES_ALL.org_id%TYPE
221: ,Payment_Function AP_INVOICES_ALL.payment_function%TYPE
222: ,Pay_Proc_Trxn_Type_Code AP_INVOICES_ALL.pay_proc_trxn_type_code%TYPE

Line 219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE

215: ,Party_Site_Id AP_INVOICES_ALL.party_site_id%TYPE
216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE
217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE
218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE
219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE
220: ,Org_id AP_INVOICES_ALL.org_id%TYPE
221: ,Payment_Function AP_INVOICES_ALL.payment_function%TYPE
222: ,Pay_Proc_Trxn_Type_Code AP_INVOICES_ALL.pay_proc_trxn_type_code%TYPE
223: );

Line 220: ,Org_id AP_INVOICES_ALL.org_id%TYPE

216: ,External_Bank_Account_Id AP_PAYMENT_SCHEDULES_ALL.external_bank_account_id%TYPE
217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE
218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE
219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE
220: ,Org_id AP_INVOICES_ALL.org_id%TYPE
221: ,Payment_Function AP_INVOICES_ALL.payment_function%TYPE
222: ,Pay_Proc_Trxn_Type_Code AP_INVOICES_ALL.pay_proc_trxn_type_code%TYPE
223: );
224:

Line 221: ,Payment_Function AP_INVOICES_ALL.payment_function%TYPE

217: ,Pmt_Currency_code AP_INVOICES_ALL.payment_currency_code%TYPE
218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE
219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE
220: ,Org_id AP_INVOICES_ALL.org_id%TYPE
221: ,Payment_Function AP_INVOICES_ALL.payment_function%TYPE
222: ,Pay_Proc_Trxn_Type_Code AP_INVOICES_ALL.pay_proc_trxn_type_code%TYPE
223: );
224:
225: l_vendor_rec r_vendor_info;

Line 222: ,Pay_Proc_Trxn_Type_Code AP_INVOICES_ALL.pay_proc_trxn_type_code%TYPE

218: ,Payment_Method AP_INVOICES_ALL.Payment_Method_Code%TYPE
219: ,Inv_Currency_code AP_INVOICES_ALL.invoice_currency_code%TYPE
220: ,Org_id AP_INVOICES_ALL.org_id%TYPE
221: ,Payment_Function AP_INVOICES_ALL.payment_function%TYPE
222: ,Pay_Proc_Trxn_Type_Code AP_INVOICES_ALL.pay_proc_trxn_type_code%TYPE
223: );
224:
225: l_vendor_rec r_vendor_info;
226: l_inv_rec r_apinv_info;

Line 325: ap_invoices_all ai

321: l_inv_rec.org_id,
322: l_inv_rec.payment_function,
323: l_inv_rec.pay_proc_trxn_type_code
324: FROM ap_invoices_ready_to_pay_v apiv,
325: ap_invoices_all ai
326: WHERE apiv.invoice_id = ai.invoice_id
327: AND apiv.invoice_id = p_invoice_id
328: AND apiv.payment_method_code = NVL(p_payment_method_code,
329: apiv.payment_method_code)