[Home] [Help]
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: */
271: select 'LOSS' invoice_type_lookup_code,
272: nvl(accounted_cr,0) credit_val, /*Added by nprashar for bug # 12843559*/
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
284: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
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: */
306: /* Commented query 4 by nprashar for bug 8307469 as query 3 and 4 are identical
307: select 'LOSS' invoice_type_lookup_code,
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
320: xal.ae_header_id = xah.ae_header_id AND
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: */
346: select 'LOSS' invoice_type_lookup_code,
347: nvl(accounted_cr,0) credit_val, /*Added by nprashar for bug # 12843559*/
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
359: where xal.application_id = 200 AND
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:
390: select 'LOSS' invoice_type_lookup_code,
391: 0 credit_val,
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
403: where xal.application_id = 200 AND
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: */
742: select 'GAIN' invoice_type_lookup_code,
743: 0 debit_val,
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
755: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
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: */
777: /*Commented Query 4 by nprashar for bug 8307469 as query3 and 4 identical
778: select 'GAIN' invoice_type_lookup_code,
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
791: xal.ae_header_id = xah.ae_header_id AND
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: */
817: select 'GAIN' invoice_type_lookup_code,
818: 0 debit_val,
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
830: where xal.application_id = 200 AND
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:
862: select 'GAIN' invoice_type_lookup_code,
863: 0 debit_val,
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
875: where xal.application_id = 200 AND