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.JAI_CMN_ST_FORMS_PKG dependencies on AP_INVOICES_ALL

Line 76: from ap_invoices_all

72:
73:
74: cursor c_get_ven_info(p_invoice_id number) is
75: select vendor_id, vendor_site_id, org_id
76: from ap_invoices_all
77: where invoice_id = p_invoice_id;
78:
79: cursor c_get_st_hdr_id(p_stform_type varchar2, p_vendor_id number, p_vendor_site_id number, p_org_id number) is
80: select st_hdr_id

Line 149: v_vendor_id ap_invoices_all.vendor_id%type;

145: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;
146: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
147: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
148:
149: v_vendor_id ap_invoices_all.vendor_id%type;
150: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
151: v_org_id ap_invoices_all.org_id%type;
152:
153: /*

Line 150: v_vendor_site_id ap_invoices_all.vendor_site_id%type;

146: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
147: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
148:
149: v_vendor_id ap_invoices_all.vendor_id%type;
150: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
151: v_org_id ap_invoices_all.org_id%type;
152:
153: /*
154: Variable declaration changed by aiyer for the bug #3249375.

Line 151: v_org_id ap_invoices_all.org_id%type;

147: v_stform_type JAI_CMN_TAXES_ALL.stform_type%type;
148:
149: v_vendor_id ap_invoices_all.vendor_id%type;
150: v_vendor_site_id ap_invoices_all.vendor_site_id%type;
151: v_org_id ap_invoices_all.org_id%type;
152:
153: /*
154: Variable declaration changed by aiyer for the bug #3249375.
155: Changed the variable declaration from reference to ja_in_po_st_forms_hdr.form_issue_id to JAI_CMN_STFORM_HDRS_ALL.st_hdr_id.

Line 222: v_set_of_books_id ap_invoices_all.set_of_books_id%type;

218: v_precedence_non_0 number;
219:
220: v_tax_base_amt number;
221: v_tax_base_amt_loop number; /*Added by nprashar for bug # 9830853*/
222: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
223: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
224: v_exchange_date ap_invoices_all.exchange_date%type;
225: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
226: v_exchange_rate ap_invoices_all.exchange_rate%type;

Line 223: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;

219:
220: v_tax_base_amt number;
221: v_tax_base_amt_loop number; /*Added by nprashar for bug # 9830853*/
222: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
223: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
224: v_exchange_date ap_invoices_all.exchange_date%type;
225: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
226: v_exchange_rate ap_invoices_all.exchange_rate%type;
227:

Line 224: v_exchange_date ap_invoices_all.exchange_date%type;

220: v_tax_base_amt number;
221: v_tax_base_amt_loop number; /*Added by nprashar for bug # 9830853*/
222: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
223: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
224: v_exchange_date ap_invoices_all.exchange_date%type;
225: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
226: v_exchange_rate ap_invoices_all.exchange_rate%type;
227:
228: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;

Line 225: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;

221: v_tax_base_amt_loop number; /*Added by nprashar for bug # 9830853*/
222: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
223: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
224: v_exchange_date ap_invoices_all.exchange_date%type;
225: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
226: v_exchange_rate ap_invoices_all.exchange_rate%type;
227:
228: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
229:

Line 226: v_exchange_rate ap_invoices_all.exchange_rate%type;

222: v_set_of_books_id ap_invoices_all.set_of_books_id%type;
223: v_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
224: v_exchange_date ap_invoices_all.exchange_date%type;
225: v_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
226: v_exchange_rate ap_invoices_all.exchange_rate%type;
227:
228: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type;
229:
230: v_line_number ap_invoice_lines_all.line_number%type ;

Line 238: from ap_invoices_all

234: p_prec_check v_prec_check;
235:
236: cursor c_get_invoice_currency_dtl is
237: select set_of_books_id, invoice_currency_code,exchange_date, exchange_rate_type, exchange_rate
238: from ap_invoices_all
239: where invoice_id = p_invoice_id;
240:
241: /* uptake of ap_invoice_lines_all */
242: /*Bug 14277151 - Added Match Type*/

Line 572: from ap_invoices_all a

568:
569: for c_invoices in
570: (
571: select invoice_id, invoice_num, cancelled_date
572: from ap_invoices_all a
573: where invoice_date between trunc(p_invoice_from_date) and trunc(p_invoice_to_date)
574: and ( (p_org_id is null) or (p_org_id is not null and org_id = p_org_id) )
575: and ( (p_vendor_id is null) or (p_vendor_id is not null and vendor_id = p_vendor_id) )
576: and ( (p_vendor_site_id is null)