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 112: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175

108: rctl.interface_line_attribute6
109: FROM
110: ra_customer_trx_all trx ,
111: ra_customer_trx_lines_all rctl ,
112: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175
113: -- ja_in_ra_customer_trx_lines jrctl
114: JAI_AR_TRXS jrct --bug#5194107
115: WHERE
116: trx.customer_trx_id = rctl.customer_trx_id

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

153:
154: ld_start_date DATE ;
155: ld_end_date DATE ;
156: --Commented below for bug#7621541
157: --ln_excise_invoice_no JAI_AR_TRX_LINES.excise_invoice_no%TYPE; --Added by Anujsax for bug#5636544
158: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_No%TYPE; --added for bug#6685050
159: lv_same_inv_no VARCHAR2(1); --added for bug#6685050
160: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
161:

Line 163: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;

159: lv_same_inv_no VARCHAR2(1); --added for bug#6685050
160: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
161:
162: --start additions for bug#5194107
163: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;
164: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;
165: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;
166:
167: BEGIN

Line 164: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;

160: lv_updt_exc_no VARCHAR2(1); --added for bug#6685050
161:
162: --start additions for bug#5194107
163: ln_last_updated_by JAI_AR_TRX_LINES.LAST_UPDATED_BY%TYPE ;
164: ln_last_update_login JAI_AR_TRX_LINES.LAST_UPDATE_LOGIN%TYPE ;
165: ld_vat_invoice_date JAI_AR_TRXs.VAT_INVOICE_DATE%TYPE;
166:
167: BEGIN
168: /*

Line 200: update JAI_AR_TRX_LINES

196: CLOSE c_same_inv_no;
197: -- bug#6685050, end
198: 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
199: loop
200: update JAI_AR_TRX_LINES
201: set excise_invoice_no = ex_inv_rec.excise_invoice_no ,
202: excise_invoice_date = ex_inv_rec.excise_invoice_date
203: where customer_trx_line_id = delivery_rec.customer_trx_line_id;
204: /* --Commented below for bug#7621541