[Home] [Help]
261: UNION ALL
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.
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
283: xal.ae_header_id = xah.ae_header_id AND
296: union all
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.
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
319: where xal.application_id = 200 AND
336: union all Commenting ends */
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.
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 ,
358: ap_invoice_payments_all app
380: union all
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.
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 ,
402: ap_invoice_payments_all app
732: UNION ALL
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.
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
754: xal.ae_header_id = xah.ae_header_id AND
767: union all
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.
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
790: WHERE xal.application_id = 200 AND
807: union all Commenting Ends*/
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.
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 ,
829: ap_invoice_payments_all app
852: union all
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.
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 ,
874: ap_invoice_payments_all app