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 XLA_AE_LINES

Line 253: and xla_ae_lines instead of xla_ae_lines.

249: -- query 3
250: /* Gain or Loss source AP_INVOICES */
251: /* Bug 4997569. Added by Lakshmi Gopalsami
252: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
253: and xla_ae_lines instead of xla_ae_lines.
254: (2) Changed ae_line_type_code to accounting_class_code
255: (3) Also added xla_transaction_entities to get the entity_id and
256: source_int_id_1 so that it can be joined with transaction tables.
257: */

Line 265: FROM xla_ae_lines xal,

261: xal.currency_conversion_rate exchange_rate ,
262: xal.currency_conversion_type exchange_rate_type,
263: xal.currency_code invoice_currency_code,
264: xal.currency_conversion_date exchange_date
265: FROM xla_ae_lines xal,
266: xla_ae_headers xah,
267: xla_transaction_entities xte,
268: ap_invoices_all api
269: WHERE xal.application_id = 200 AND

Line 286: and xla_ae_lines instead of xla_ae_lines.

282: -- Query 4
283: /* Gain or Loss source AP_INVOICE_DISTRIBUTIONS */
284: /* Bug 4997569. Added by Lakshmi Gopalsami
285: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
286: and xla_ae_lines instead of xla_ae_lines.
287: (2) Changed ae_line_type_code to accounting_class_code
288: (3) Also added xla_transaction_entities to get the entity_id and
289: source_int_id_1 so that it can be joined with transaction tables.
290: */

Line 298: from xla_ae_lines xal,

294: xal.currency_conversion_rate exchange_rate ,
295: xal.currency_conversion_type exchange_rate_type,
296: xal.currency_code invoice_currency_code,
297: xal.currency_conversion_date exchange_date
298: from xla_ae_lines xal,
299: xla_ae_headers xah,
300: xla_transaction_entities xte,
301: ap_invoices_all api,
302: ap_invoice_distributions_all apd

Line 323: and xla_ae_lines instead of xla_ae_lines.

319: -- Query 5
320: /* Gain or Loss source AP_CHECKS */
321: /* Bug 4997569. Added by Lakshmi Gopalsami
322: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
323: and xla_ae_lines instead of xla_ae_lines.
324: (2) Changed ae_line_type_code to accounting_class_code
325: (3) Also added xla_transaction_entities to get the entity_id and
326: source_int_id_1 so that it can be joined with transaction tables.
327: */

Line 335: from xla_ae_lines xal,

331: xal.currency_conversion_rate exchange_rate ,
332: xal.currency_conversion_type exchange_rate_type,
333: xal.currency_code invoice_currency_code,
334: xal.currency_conversion_date exchange_date
335: from xla_ae_lines xal,
336: xla_ae_headers xah,
337: xla_transaction_entities xte,
338: ap_invoices_all api,
339: ap_checks_all ac ,

Line 364: and xla_ae_lines instead of xla_ae_lines.

360: -- Query 6
361: /* Gain or Loss source AP_INVOICE_PAYMENTS*/
362: /* Bug 4997569. Added by Lakshmi Gopalsami
363: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
364: and xla_ae_lines instead of xla_ae_lines.
365: (2) Changed ae_line_type_code to accounting_class_code
366: (3) Also added xla_transaction_entities to get the entity_id and
367: source_int_id_1 so that it can be joined with transaction tables.
368: */

Line 376: from xla_ae_lines xal,

372: xal.currency_conversion_rate exchange_rate ,
373: xal.currency_conversion_type exchange_rate_type,
374: xal.currency_code invoice_currency_code,
375: xal.currency_conversion_date exchange_date
376: from xla_ae_lines xal,
377: xla_ae_headers xah,
378: xla_transaction_entities xte,
379: ap_invoices_all api,
380: ap_checks_all ac ,

Line 703: and xla_ae_lines instead of xla_ae_lines.

699: -- query 3
700: /* Gain or Loss source AP_INVOICES */
701: /* Bug 4997569. Added by Lakshmi Gopalsami
702: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
703: and xla_ae_lines instead of xla_ae_lines.
704: (2) Changed ae_line_type_code to accounting_class_code
705: (3) Also added xla_transaction_entities to get the entity_id and
706: source_int_id_1 so that it can be joined with transaction tables.
707: */

Line 715: from xla_ae_lines xal,

711: xal.currency_conversion_rate exchange_rate ,
712: xal.currency_conversion_type exchange_rate_type,
713: xal.currency_code invoice_currency_code,
714: xal.currency_conversion_date exchange_date
715: from xla_ae_lines xal,
716: xla_ae_headers xah,
717: xla_transaction_entities xte,
718: ap_invoices_all api
719: where xal.application_id = 200 AND

Line 736: and xla_ae_lines instead of xla_ae_lines.

732: -- Query 4
733: /* Gain or Loss source AP_INVOICE_DISTRIBUTIONS */
734: /* Bug 4997569. Added by Lakshmi Gopalsami
735: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
736: and xla_ae_lines instead of xla_ae_lines.
737: (2) Changed ae_line_type_code to accounting_class_code
738: (3) Also added xla_transaction_entities to get the entity_id and
739: source_int_id_1 so that it can be joined with transaction tables.
740: */

Line 748: from xla_ae_lines xal,

744: xal.currency_conversion_rate exchange_rate ,
745: xal.currency_conversion_type exchange_rate_type,
746: xal.currency_code invoice_currency_code,
747: xal.currency_conversion_date exchange_date
748: from xla_ae_lines xal,
749: xla_ae_headers xah,
750: xla_transaction_entities xte,
751: ap_invoices_all api,
752: ap_invoice_distributions_all apd

Line 773: and xla_ae_lines instead of xla_ae_lines.

769: -- Query 5
770: /* Gain or Loss source AP_CHECKS */
771: /* Bug 4997569. Added by Lakshmi Gopalsami
772: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
773: and xla_ae_lines instead of xla_ae_lines.
774: (2) Changed ae_line_type_code to accounting_class_code
775: (3) Also added xla_transaction_entities to get the entity_id and
776: source_int_id_1 so that it can be joined with transaction tables.
777: */

Line 785: from xla_ae_lines xal,

781: xal.currency_conversion_rate exchange_rate ,
782: xal.currency_conversion_type exchange_rate_type,
783: xal.currency_code invoice_currency_code,
784: xal.currency_conversion_date exchange_date
785: from xla_ae_lines xal,
786: xla_ae_headers xah,
787: xla_transaction_entities xte,
788: ap_invoices_all api,
789: ap_checks_all ac ,

Line 815: and xla_ae_lines instead of xla_ae_lines.

811: -- Query 6
812: /* Gain or Loss source AP_INVOICE_PAYMENTS*/
813: /* Bug 4997569. Added by Lakshmi Gopalsami
814: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
815: and xla_ae_lines instead of xla_ae_lines.
816: (2) Changed ae_line_type_code to accounting_class_code
817: (3) Also added xla_transaction_entities to get the entity_id and
818: source_int_id_1 so that it can be joined with transaction tables.
819: */

Line 827: from xla_ae_lines xal,

823: xal.currency_conversion_rate exchange_rate ,
824: xal.currency_conversion_type exchange_rate_type,
825: xal.currency_code invoice_currency_code,
826: xal.currency_conversion_date exchange_date
827: from xla_ae_lines xal,
828: xla_ae_headers xah,
829: xla_transaction_entities xte,
830: ap_invoices_all api,
831: ap_checks_all ac ,