[Home] [Help]
248: UNION ALL
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.
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
270: xal.ae_header_id = xah.ae_header_id AND
281: union all
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.
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
303: where xal.application_id = 200 AND
318: union all
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.
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 ,
340: ap_invoice_payments_all app
359: union all
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.
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 ,
381: ap_invoice_payments_all app
698: UNION ALL
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.
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
720: xal.ae_header_id = xah.ae_header_id AND
731: union all
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.
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
753: WHERE xal.application_id = 200 AND
768: union all
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.
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 ,
790: ap_invoice_payments_all app
810: union all
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.
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 ,
832: ap_invoice_payments_all app