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_AR_TRX_PKG dependencies on JAI_AR_TRX_LINES

Line 171: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175

167: rctl.interface_line_attribute6
168: FROM
169: ra_customer_trx_all trx ,
170: ra_customer_trx_lines_all rctl ,
171: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175
172: -- ja_in_ra_customer_trx_lines jrctl
173: JAI_AR_TRXS jrct --bug#5194107
174: WHERE
175: trx.customer_trx_id = rctl.customer_trx_id

Line 226: --ln_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%TYPE; --Added by Anujsax for bug#5636544

222:
223: ld_start_date DATE ;
224: ld_end_date DATE ;
225: --Commented below for bug#7621541
226: --ln_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%TYPE; --Added by Anujsax for bug#5636544
227: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_No%TYPE; --added for bug#6685050
228: lv_same_inv_no VARCHAR2(1); --added for bug#6685050
229: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
230:

Line 232: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;

228: lv_same_inv_no VARCHAR2(1); --added for bug#6685050
229: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
230:
231: --start additions for bug#5194107
232: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;
233: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;
234: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;
235:
236: --add by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168#,begin

Line 233: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;

229: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
230:
231: --start additions for bug#5194107
232: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;
233: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;
234: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;
235:
236: --add by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168#,begin
237: ----------------------------------------------------------------------------------------------------------------

Line 299: update JAI_AR_TRX_LINES

295: ln_vat_invoice_no := NULL;
296: ld_vat_invoice_date := NULL;
297: For ex_inv_rec in c_ex_inv_no(to_number(delivery_rec.interface_line_attribute3), to_number(delivery_rec.interface_line_attribute6))--bug#5194107
298: loop
299: update JAI_AR_TRX_LINES
300: set excise_invoice_no = ex_inv_rec.excise_invoice_no ,
301: excise_invoice_date = ex_inv_rec.excise_invoice_date
302: where customer_trx_line_id = delivery_rec.customer_trx_line_id;
303: /* --Commented below for bug#7621541

Line 704: FROM JAI_AR_TRX_LINES

700: WHERE customer_trx_id = pn_customer_trx_id;
701: -- get excise invoice number
702: CURSOR get_exc_inv_no_cur IS
703: SELECT excise_invoice_no
704: FROM JAI_AR_TRX_LINES
705: WHERE customer_trx_id = pn_customer_trx_id;
706:
707: CURSOR get_st_invoice_cur IS
708: SELECT st_inv_number

Line 714: lv_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%type;

710: WHERE customer_trx_id = pn_customer_trx_id;
711: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
712:
713: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%Type;
714: lv_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%type;
715: lv_st_invoice_num JAI_AR_TRXS.st_inv_number%Type;
716: --Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
717: lv_display_flag VARCHAR2(240);
718: lv_procedure_name VARCHAR2(40):='update_reference';