[Home] [Help]
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: */
258: select 'LOSS' invoice_type_lookup_code,
259: 0 credit_val,
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
271: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
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: */
291: select 'LOSS' invoice_type_lookup_code,
292: 0 credit_val,
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
304: xal.ae_header_id = xah.ae_header_id AND
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: */
328: select 'LOSS' invoice_type_lookup_code,
329: 0 credit_val,
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
341: where xal.application_id = 200 AND
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: */
369: select 'LOSS' invoice_type_lookup_code,
370: 0 credit_val,
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
382: where xal.application_id = 200 AND
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: */
708: select 'GAIN' invoice_type_lookup_code,
709: 0 debit_val,
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
721: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
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: */
741: select 'GAIN' invoice_type_lookup_code,
742: 0 debit_val,
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
754: xal.ae_header_id = xah.ae_header_id AND
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: */
778: select 'GAIN' invoice_type_lookup_code,
779: 0 debit_val,
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
791: where xal.application_id = 200 AND
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: */
820: select 'GAIN' invoice_type_lookup_code,
821: 0 debit_val,
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
833: where xal.application_id = 200 AND