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 266: and xla_ae_lines instead of xla_ae_lines.

262: -- query 3
263: /* Gain or Loss source AP_INVOICES */
264: /* Bug 4997569. Added by Lakshmi Gopalsami
265: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
266: and xla_ae_lines instead of xla_ae_lines.
267: (2) Changed ae_line_type_code to accounting_class_code
268: (3) Also added xla_transaction_entities to get the entity_id and
269: source_int_id_1 so that it can be joined with transaction tables.
270: */

Line 278: FROM xla_ae_lines xal,

274: xal.currency_conversion_rate exchange_rate ,
275: xal.currency_conversion_type exchange_rate_type,
276: xal.currency_code invoice_currency_code,
277: xal.currency_conversion_date exchange_date
278: FROM xla_ae_lines xal,
279: xla_ae_headers xah,
280: xla_transaction_entities xte,
281: ap_invoices_all api
282: WHERE xal.application_id = 200 AND

Line 301: and xla_ae_lines instead of xla_ae_lines.

297: -- Query 4
298: /* Gain or Loss source AP_INVOICE_DISTRIBUTIONS */
299: /* Bug 4997569. Added by Lakshmi Gopalsami
300: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
301: and xla_ae_lines instead of xla_ae_lines.
302: (2) Changed ae_line_type_code to accounting_class_code
303: (3) Also added xla_transaction_entities to get the entity_id and
304: source_int_id_1 so that it can be joined with transaction tables.
305: */

Line 314: from xla_ae_lines xal,

310: xal.currency_conversion_rate exchange_rate ,
311: xal.currency_conversion_type exchange_rate_type,
312: xal.currency_code invoice_currency_code,
313: xal.currency_conversion_date exchange_date
314: from xla_ae_lines xal,
315: xla_ae_headers xah,
316: xla_transaction_entities xte,
317: ap_invoices_all api,
318: ap_invoice_distributions_all apd --Commented by nprashar for bug 8307469

Line 341: and xla_ae_lines instead of xla_ae_lines.

337: -- Query 5
338: /* Gain or Loss source AP_CHECKS */
339: /* Bug 4997569. Added by Lakshmi Gopalsami
340: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
341: and xla_ae_lines instead of xla_ae_lines.
342: (2) Changed ae_line_type_code to accounting_class_code
343: (3) Also added xla_transaction_entities to get the entity_id and
344: source_int_id_1 so that it can be joined with transaction tables.
345: */

Line 353: from xla_ae_lines xal,

349: xal.currency_conversion_rate exchange_rate ,
350: xal.currency_conversion_type exchange_rate_type,
351: xal.currency_code invoice_currency_code,
352: xal.currency_conversion_date exchange_date
353: from xla_ae_lines xal,
354: xla_ae_headers xah,
355: xla_transaction_entities xte,
356: ap_invoices_all api,
357: ap_checks_all ac ,

Line 385: and xla_ae_lines instead of xla_ae_lines.

381: -- Query 6
382: Gain or Loss source AP_INVOICE_PAYMENTS
383: Bug 4997569. Added by Lakshmi Gopalsami
384: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
385: and xla_ae_lines instead of xla_ae_lines.
386: (2) Changed ae_line_type_code to accounting_class_code
387: (3) Also added xla_transaction_entities to get the entity_id and
388: source_int_id_1 so that it can be joined with transaction tables.
389:

Line 397: from xla_ae_lines xal,

393: xal.currency_conversion_rate exchange_rate ,
394: xal.currency_conversion_type exchange_rate_type,
395: xal.currency_code invoice_currency_code,
396: xal.currency_conversion_date exchange_date
397: from xla_ae_lines xal,
398: xla_ae_headers xah,
399: xla_transaction_entities xte,
400: ap_invoices_all api,
401: ap_checks_all ac ,

Line 737: and xla_ae_lines instead of xla_ae_lines.

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

Line 749: from xla_ae_lines xal,

745: xal.currency_conversion_rate exchange_rate ,
746: xal.currency_conversion_type exchange_rate_type,
747: xal.currency_code invoice_currency_code,
748: xal.currency_conversion_date exchange_date
749: from xla_ae_lines xal,
750: xla_ae_headers xah,
751: xla_transaction_entities xte,
752: ap_invoices_all api
753: where xal.application_id = 200 AND

Line 772: and xla_ae_lines instead of xla_ae_lines.

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

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_invoice_distributions_all apd --Commented by nprashar for bug # 8307469

Line 812: and xla_ae_lines instead of xla_ae_lines.

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

Line 824: from xla_ae_lines xal,

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

Line 857: and xla_ae_lines instead of xla_ae_lines.

853: -- Query 6
854: Gain or Loss source AP_INVOICE_PAYMENTS
855: Bug 4997569. Added by Lakshmi Gopalsami
856: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
857: and xla_ae_lines instead of xla_ae_lines.
858: (2) Changed ae_line_type_code to accounting_class_code
859: (3) Also added xla_transaction_entities to get the entity_id and
860: source_int_id_1 so that it can be joined with transaction tables.
861:

Line 869: from xla_ae_lines xal,

865: xal.currency_conversion_rate exchange_rate ,
866: xal.currency_conversion_type exchange_rate_type,
867: xal.currency_code invoice_currency_code,
868: xal.currency_conversion_date exchange_date
869: from xla_ae_lines xal,
870: xla_ae_headers xah,
871: xla_transaction_entities xte,
872: ap_invoices_all api,
873: ap_checks_all ac ,