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_AP_RPT_APCR_PKG dependencies on AP_AE_LINES_ALL

Line 61: ap_ae_lines_all table.

57: 4. 16/01/2003 Aparajita for bug # 2545466. Version# 615.4
58:
59: Broke the GAIN/LOSS query in the cursor into 4 queries to take care of the
60: 4 different source from which the gain loss record gets populated into
61: ap_ae_lines_all table.
62:
63: Also removed the old code that was earlier commented at the end of this code.
64:
65: There was inconsistancy between the logic followed in the report and this

Line 163: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS

159: -- Bug 4997569. Added by Lakshmi Gopalsami
160: lv_inv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
161: lv_pay_entity_code CONSTANT varchar2(30) := 'AP_PAYMENTS';
162:
163: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS
164: -- query 1
165: --Removed discount_amount_taken from amount for the bug#7689858
166: SELECT api.invoice_type_lookup_code,
167: DECODE(api.invoice_type_lookup_code,

Line 532: gets populated into ap_ae_lines_all table.

528: 4. 16/01/2003 Aparajita for bug # 2545466. Version # 615.4
529:
530: Broke the GAIN/LOSS query in the cursor into 4 queries to take
531: care of the 4 different source from which the gain loss record
532: gets populated into ap_ae_lines_all table.
533:
534: Also removed the old code that was earlier commented at the end
535: of this code.
536:

Line 630: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS --rchandan for bug#4428980

626: lv_inv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
627: lv_pay_entity_code CONSTANT varchar2(30) := 'AP_PAYMENTS';
628:
629:
630: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS --rchandan for bug#4428980
631: -- query 1
632: --Removed discount_amount_taken from debit_val for the bug#7689858
633: SELECT api.invoice_type_lookup_code,
634: DECODE(api.invoice_type_lookup_code,