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 AP_INVOICES_ALL

Line 82: the join condition between ap_invoices_all and

78: Fix: i)The TRUNC function around the date fields suppress the use of index.
79: Removed the TRUNC function from all SELECT statments.
80:
81: ii)In query4 Gain or Loss source AP_INVOICE_DISTRIBUTIONS,
82: the join condition between ap_invoices_all and
83: ap_invoice_distributions_all was missing. Corrected the same.
84:
85: 6. 22/01/2004 Aparajita for Bug#3392495. Version#618.1
86: Added code to reduce the invoice amount by discount amount already given.

Line 172: FROM ap_invoices_all api,

168: api.exchange_rate exchange_rate,
169: api.exchange_rate_type exchange_rate_type,
170: api.invoice_currency_code invoice_currency_code,
171: api.exchange_date exchange_date
172: FROM ap_invoices_all api,
173: ap_invoice_distributions_all apd,
174: (SELECT NVL(SUM(apd.amount),0) amt_val,
175: api.invoice_id
176: FROM ap_invoices_all api,

Line 176: FROM ap_invoices_all api,

172: FROM ap_invoices_all api,
173: ap_invoice_distributions_all apd,
174: (SELECT NVL(SUM(apd.amount),0) amt_val,
175: api.invoice_id
176: FROM ap_invoices_all api,
177: ap_invoice_distributions_all apd
178: WHERE api.invoice_id = apd.invoice_id
179: AND api.invoice_type_lookup_code <> lv_prepayment --rchandan for bug#4428980
180: AND apd.match_status_flag = 'A'

Line 229: FROM ap_invoices_all api,

225: apc.exchange_rate exchange_rate,
226: apc.exchange_rate_type exchange_rate_type,
227: api.payment_currency_code invoice_currency_code,
228: apc.exchange_date exchange_date
229: FROM ap_invoices_all api,
230: ap_invoice_distributions_all apd,
231: ap_invoice_payments_all app,
232: ap_checks_all apc
233: WHERE api.invoice_id = apd.invoice_id

Line 268: ap_invoices_all api

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
272: xah.application_id = 200 AND

Line 301: ap_invoices_all api,

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
305: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980

Line 338: ap_invoices_all api,

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
342: xal.ae_header_id = xah.ae_header_id AND

Line 379: ap_invoices_all api,

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
383: xal.ae_header_id = xah.ae_header_id AND

Line 533: between ap_invoices_all and ap_invoice_distributions_all was missing.

529: i)The TRUNC function around the date fields suppress the use of index.
530: Removed the TRUNC function from all SELECT statments.
531:
532: ii)In query4 Gain or Loss source AP_INVOICE_DISTRIBUTIONS, the join condition
533: between ap_invoices_all and ap_invoice_distributions_all was missing.
534: Corrected the same.
535:
536: 6. 22/01/2004 Aparajita for Bug#3392495. Version#115.1
537: Added code to reduce the invoice amount by discount amount already given.

Line 620: FROM ap_invoices_all api,

616: api.exchange_rate exchange_rate,
617: api.exchange_rate_type exchange_rate_type,
618: api.invoice_currency_code invoice_currency_code,
619: api.exchange_date exchange_date
620: FROM ap_invoices_all api,
621: ap_invoice_distributions_all apd,
622: (SELECT NVL(SUM(apd.amount),0) amt_val, /* Bug#3390665*/
623: api.invoice_id
624: FROM ap_invoices_all api,

Line 624: FROM ap_invoices_all api,

620: FROM ap_invoices_all api,
621: ap_invoice_distributions_all apd,
622: (SELECT NVL(SUM(apd.amount),0) amt_val, /* Bug#3390665*/
623: api.invoice_id
624: FROM ap_invoices_all api,
625: ap_invoice_distributions_all apd
626: WHERE api.invoice_id = apd.invoice_id
627: AND api.invoice_type_lookup_code <> lv_prepayment --rchandan for bug#4428980
628: AND apd.match_status_flag = 'A'

Line 679: FROM ap_invoices_all api,

675: apc.exchange_rate exchange_rate,
676: apc.exchange_rate_type exchange_rate_type,
677: api.payment_currency_code invoice_currency_code,
678: apc.exchange_date exchange_date
679: FROM ap_invoices_all api,
680: ap_invoice_distributions_all apd,
681: ap_invoice_payments_all app,
682: ap_checks_all apc
683: WHERE api.invoice_id = apd.invoice_id

Line 718: ap_invoices_all api

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
722: xah.application_id = 200 AND

Line 751: ap_invoices_all api,

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
755: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980

Line 788: ap_invoices_all api,

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
792: xal.ae_header_id = xah.ae_header_id AND

Line 830: ap_invoices_all api,

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
834: xal.ae_header_id = xah.ae_header_id AND

Line 931: from ap_invoices_all aia

927:
928: cursor c_inv_select_cursor( c_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE ) IS --rchandan for bug#4428980
929: select invoice_id, invoice_num, org_id, vendor_id, vendor_site_id, invoice_date,
930: invoice_currency_code, nvl(exchange_rate,1) exchange_rate, voucher_num
931: from ap_invoices_all aia
932: where cancelled_date is null
933: and (p_vendor_id is null or vendor_id = p_vendor_id)
934: and (p_vendor_site_id is null or vendor_site_id = p_vendor_site_id)
935: and (p_org_id is null or org_id = p_org_id)