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.AP_AUTOSELECT_PKG dependencies on AP_INVOICES_ALL

Line 99: FROM ap_selected_invoices_all asi,ap_invoices_all ai

95: SELECT asi.invoice_id
96: ,asi.vendor_id
97: ,asi.vendor_site_id
98: ,asi.remit_to_supplier_site_id
99: FROM ap_selected_invoices_all asi,ap_invoices_all ai
100: WHERE ai.invoice_id=asi.invoice_id
101: AND ai.invoice_type_lookup_code in ('STANDARD','PREPAYMENT')
102: AND AP_UTILITIES_PKG.GET_CCR_STATUS(asi.vendor_id,'S') <> 'F'
103: AND asi.checkrun_id=p_checkrun_id;

Line 280: ap_invoices AI, --Bug6040657. Changed from ap_invoices_all to ap_invoices

276: 'Y', AI.exclusive_payment_flag, 'N'),
277: asp.interest_accts_pay_ccid,
278: ai.org_id
279: FROM /* ap_interest_periods, Bug#12835170 */
280: ap_invoices AI, --Bug6040657. Changed from ap_invoices_all to ap_invoices
281: ap_selected_invoices_all ASI,
282: po_vendors pov,
283: ap_system_parameters_all asp
284: WHERE ASI.checkrun_id = P_checkrun_id

Line 893: ' ap_invoices ai, '|| /* inv, '|| Commented for bug#9182499 GSCC Error File.Sql.6 Bug6040657. Changed from ap_invoices_all to ap_invoices */

889: ' ps.due_date, '||
890: ' ps.discount_amount_available, '||
891: ' ps.discount_date '||
892: ' FROM ap_supplier_sites_all sites, '||
893: ' ap_invoices ai, '|| /* inv, '|| Commented for bug#9182499 GSCC Error File.Sql.6 Bug6040657. Changed from ap_invoices_all to ap_invoices */
894: ' ap_payment_schedules ps, '||
895: ' ap_suppliers suppliers, '||
896: ' hz_parties hz '||
897: ' where ai.invoice_id = ps.invoice_id '||

Line 1359: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices

1355: ipm.support_bills_payable_flag, -- Bug 5357689, 5479979
1356: (trunc(aps.due_date) + nvl(ipm.maturity_date_offset_days,0)) due_date -- Bug 5357689
1357: --Bug 543942 added NVL in the above scenario
1358: from ap_selected_invoices_all asi,
1359: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices
1360: ap_inv_selection_criteria_all aisc,
1361: ap_payment_schedules_all aps,
1362: fv_tpp_assignments_v fv, --5017076
1363: iby_payment_methods_vl ipm -- Bug 5357689

Line 2965: ' ap_invoices ai, '|| /* inv, '||Commented for bug#9182499 --Bug6040657. Changed from ap_invoices_all to ap_invoices */

2961: ' ,ps.remit_to_supplier_site_id remit_to_supplier_site_id '||
2962: --End 8217641
2963: ' FROM ap_supplier_sites_all sites, '||
2964: ' ap_suppliers suppliers, '||
2965: ' ap_invoices ai, '|| /* inv, '||Commented for bug#9182499 --Bug6040657. Changed from ap_invoices_all to ap_invoices */
2966: ' ap_payment_schedules_all ps, '||
2967: ' ap_system_parameters_all asp, '||
2968: ' hz_parties hzp, '||
2969: ' hz_party_sites hzps, '||-- Bug 5620285

Line 3788: ' ap_invoices ai, '|| /* inv, '|| Commented for bug#9182499 GSCC Error File.Sql.6 --Bug6040657. Changed from ap_invoices_all to ap_invoices */

3784: ' ,ps.remit_to_supplier_site_id remit_to_supplier_site_id '||
3785: --End 8217641
3786: ' FROM ap_supplier_sites_all sites, '||
3787: ' ap_suppliers suppliers, '||
3788: ' ap_invoices ai, '|| /* inv, '|| Commented for bug#9182499 GSCC Error File.Sql.6 --Bug6040657. Changed from ap_invoices_all to ap_invoices */
3789: ' ap_payment_schedules_all ps, '||
3790: ' ap_system_parameters_all asp, '||
3791: ' hz_parties hzp, '||
3792: ' hz_party_sites hzps, '|| -- Bug 5620285

Line 4524: FROM AP_INVOICES_ALL AI

4520: AND ASI2.CHECKRUN_ID = l_checkrun_id
4521: --introduced for 8403042/8404650
4522: AND EXISTS
4523: (SELECT 1
4524: FROM AP_INVOICES_ALL AI
4525: WHERE AI.INVOICE_ID = ASI2.INVOICE_ID
4526: AND NVL(AI.RELATIONSHIP_ID,-1) <> -1)
4527: --end of 8403042/8404650
4528: AND NOT EXISTS

Line 4725: ap_invoices ai --Bug6040657. Changed from ap_invoices_all to ap_invoices

4721: * (PS.AMOUNT_REMAINING / DECODE(PS.GROSS_AMOUNT,
4722: 0, 1,
4723: prorated_awt_gross_amt(ps.invoice_id, ps.payment_num) )))))
4724: FROM ap_payment_schedules_all PS,
4725: ap_invoices ai --Bug6040657. Changed from ap_invoices_all to ap_invoices
4726: WHERE PS.invoice_id = asi.invoice_id
4727: AND PS.payment_num = asi.payment_num
4728: and ai.invoice_id = ps.invoice_id)
4729: WHERE checkrun_id = l_checkrun_id;

Line 5412: from ap_invoices_all

5408: END IF;
5409:
5410: update ap_selected_invoices_all asi
5411: set exclusive_payment_flag = (select nvl(exclusive_payment_flag, 'N')
5412: from ap_invoices_all
5413: where invoice_id = asi.invoice_id)
5414: where checkrun_id = p_checkrun_id
5415: and exists
5416: ( select 1

Line 6395: FROM ap_invoice_lines_all ail,ap_invoices_all ai

6391: l_prepay_with_tax NUMBER;
6392: BEGIN
6393: SELECT ((0 - SUM(NVL(ail.amount,0)))*ai.payment_cross_rate)
6394: INTO l_prepay_with_tax
6395: FROM ap_invoice_lines_all ail,ap_invoices_all ai
6396: WHERE ail.invoice_id = p_invoice_id
6397: AND ail.invoice_id=ai.invoice_id
6398: AND ail.prepay_invoice_id is not null
6399: AND ail.line_type_lookup_code in ('TAX', 'PREPAY')

Line 6455: , ap_invoices_all i

6451: WHERE si.checkrun_id = p_checkrun_id
6452: AND si.invoice_id in
6453: (select /*+ use_nl_index(I AP_INVOICES_U1) */ si2.invoice_id
6454: from ap_selected_invoices_all si2
6455: , ap_invoices_all i
6456: where si2.checkrun_id = p_checkrun_id
6457: and si2.invoice_id = i.invoice_id
6458: and si2.original_invoice_id is null
6459: group by si2.invoice_id,i.invoice_amount, decode(i.net_of_retainage_flag, 'Y', 0,