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 23: p_accts ap_invoices_all.accts_pay_code_combination_id%TYPE DEFAULT NULL

19: p_set_of_books_id NUMBER,
20: p_vendor_site_code VARCHAR2,
21: p_org_id NUMBER ,-- added by Aparajita on 26-sep-2002 for bug # 2574262
22: p_currency_code VARCHAR2 DEFAULT NULL, /* added by vumaasha for bug 8310720 */
23: p_accts ap_invoices_all.accts_pay_code_combination_id%TYPE DEFAULT NULL
24: )
25: RETURN NUMBER
26: IS
27: /*------------------------------------------------------------------------------

Line 84: the join condition between ap_invoices_all and

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

Line 177: FROM ap_invoices_all api,

173: api.exchange_rate exchange_rate,
174: api.exchange_rate_type exchange_rate_type,
175: api.invoice_currency_code invoice_currency_code,
176: api.exchange_date exchange_date
177: FROM ap_invoices_all api,
178: ap_invoice_distributions_all apd,
179: (SELECT NVL(SUM(apd.amount),0) amt_val,
180: api.invoice_id
181: FROM ap_invoices_all api,

Line 181: FROM ap_invoices_all api,

177: FROM ap_invoices_all api,
178: ap_invoice_distributions_all apd,
179: (SELECT NVL(SUM(apd.amount),0) amt_val,
180: api.invoice_id
181: FROM ap_invoices_all api,
182: ap_invoice_distributions_all apd
183: WHERE api.invoice_id = apd.invoice_id
184: AND api.invoice_type_lookup_code <> lv_prepayment --rchandan for bug#4428980
185: AND apd.match_status_flag = 'A'

Line 237: FROM ap_invoices_all api,

233: apc.exchange_rate exchange_rate,
234: apc.exchange_rate_type exchange_rate_type,
235: api.payment_currency_code invoice_currency_code,
236: apc.exchange_date exchange_date
237: FROM ap_invoices_all api,
238: --ap_invoice_distributions_all apd,Commented by nprashar for bug 8307469
239: ap_invoice_payments_all app,
240: ap_checks_all apc
241: WHERE /*api.invoice_id = apd.invoice_id

Line 281: ap_invoices_all api

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

Line 317: ap_invoices_all api,

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

Line 356: ap_invoices_all api,

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

Line 400: ap_invoices_all api,

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

Line 490: p_accts ap_invoices_all.accts_pay_code_combination_id%TYPE DEFAULT NULL

486: p_set_of_books_id NUMBER,
487: p_vendor_site_code VARCHAR2,
488: p_org_id NUMBER, -- added by Aparajita on 26-sep-2002 for bug # 2574262
489: p_currency_code VARCHAR2 DEFAULT NULL, /* added by vumaasha for bug 8310720 */
490: p_accts ap_invoices_all.accts_pay_code_combination_id%TYPE DEFAULT NULL
491: )
492: RETURN NUMBER
493: IS
494: /*------------------------------------------------------------------------------

Line 556: between ap_invoices_all and ap_invoice_distributions_all was missing.

552: i)The TRUNC function around the date fields suppress the use of index.
553: Removed the TRUNC function from all SELECT statments.
554:
555: ii)In query4 Gain or Loss source AP_INVOICE_DISTRIBUTIONS, the join condition
556: between ap_invoices_all and ap_invoice_distributions_all was missing.
557: Corrected the same.
558:
559: 6. 22/01/2004 Aparajita for Bug#3392495. Version#115.1
560: Added code to reduce the invoice amount by discount amount already given.

Line 645: FROM ap_invoices_all api,

641: api.exchange_rate exchange_rate,
642: api.exchange_rate_type exchange_rate_type,
643: api.invoice_currency_code invoice_currency_code,
644: api.exchange_date exchange_date
645: FROM ap_invoices_all api,
646: ap_invoice_distributions_all apd,
647: (SELECT NVL(SUM(apd.amount),0) amt_val, /* Bug#3390665*/
648: api.invoice_id
649: FROM ap_invoices_all api,

Line 649: FROM ap_invoices_all api,

645: FROM ap_invoices_all api,
646: ap_invoice_distributions_all apd,
647: (SELECT NVL(SUM(apd.amount),0) amt_val, /* Bug#3390665*/
648: api.invoice_id
649: FROM ap_invoices_all api,
650: ap_invoice_distributions_all apd
651: WHERE api.invoice_id = apd.invoice_id
652: AND api.invoice_type_lookup_code <> lv_prepayment --rchandan for bug#4428980
653: AND apd.match_status_flag = 'A'

Line 708: FROM ap_invoices_all api,

704: apc.exchange_rate exchange_rate,
705: apc.exchange_rate_type exchange_rate_type,
706: api.payment_currency_code invoice_currency_code,
707: apc.exchange_date exchange_date
708: FROM ap_invoices_all api,
709: --ap_invoice_distributions_all apd, Commented by nprashar for bug # 8307469
710: ap_invoice_payments_all app,
711: ap_checks_all apc
712: WHERE /*api.invoice_id = apd.invoice_id

Line 752: ap_invoices_all api

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

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

Line 827: ap_invoices_all api,

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

Line 872: ap_invoices_all api,

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

Line 973: from ap_invoices_all aia

969:
970: cursor c_inv_select_cursor( c_line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE ) IS --rchandan for bug#4428980
971: select invoice_id, invoice_num, org_id, vendor_id, vendor_site_id, invoice_date,
972: invoice_currency_code, nvl(exchange_rate,1) exchange_rate, voucher_num
973: from ap_invoices_all aia
974: where cancelled_date is null
975: and (p_vendor_id is null or vendor_id = p_vendor_id)
976: and (p_vendor_site_id is null or vendor_site_id = p_vendor_site_id)
977: and (p_org_id is null or org_id = p_org_id)