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_MASS_ADDITIONS_CREATE_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 348: FROM ap_payment_hist_dists APHD,

344: AND APIP.posted_flag = 'Y'
345: AND APIP.accounting_date <= P_acctg_date
346: AND APIP.set_of_books_id = P_ledger_id
347: AND NOT EXISTS (SELECT /*+ push_subq no_unnest */ 'Payment with discount and ATF not N'
348: FROM ap_payment_hist_dists APHD,
349: ap_invoice_distributions_all APID
350: WHERE APIP.accounting_event_id = APHD.accounting_event_id
351: AND APIP.invoice_payment_id = APHD.invoice_payment_id
352: AND APHD.pay_dist_lookup_code = 'DISCOUNT'

Line 1326: AP_PAYMENT_HIST_DISTS APHD, --Bug9967535

1322: 'NEW'
1323: FROM ap_invoice_distributions_gt APIDG,
1324: ap_invoice_lines_all APIL,
1325: ap_invoices_all API,
1326: AP_PAYMENT_HIST_DISTS APHD, --Bug9967535
1327: financials_system_params_all FSP, -- changed table order # 9669334
1328: ap_batches_all APB,
1329: po_distributions_all POD,
1330: po_headers_all POH,

Line 1512: SELECT + INDEX(aphd ap_payment_hist_dists_n5) -- Bug 8305129

1508: AND APIP.posted_flag = 'Y'
1509: AND APIP.accounting_date <= P_acctg_date
1510: AND APIP.set_of_books_id = P_ledger_id
1511: AND APIP.invoice_payment_id IN (
1512: SELECT + INDEX(aphd ap_payment_hist_dists_n5) -- Bug 8305129
1513: APHD.invoice_payment_id
1514: FROM ap_payment_hist_dists APHD,
1515: ap_invoice_distributions_all APID
1516: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id

Line 1514: FROM ap_payment_hist_dists APHD,

1510: AND APIP.set_of_books_id = P_ledger_id
1511: AND APIP.invoice_payment_id IN (
1512: SELECT + INDEX(aphd ap_payment_hist_dists_n5) -- Bug 8305129
1513: APHD.invoice_payment_id
1514: FROM ap_payment_hist_dists APHD,
1515: ap_invoice_distributions_all APID
1516: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
1517: AND APIP.ACCOUNTING_EVENT_ID=APHD.ACCOUNTING_EVENT_ID --bug5461146
1518: AND APHD.invoice_distribution_id = APID.invoice_distribution_id

Line 1787: ap_payment_hist_dists APHD,

1783: APIP.invoice_payment_id
1784: FROM ap_invoice_distributions_all APID,
1785: ap_invoice_lines_all APIL,
1786: ap_invoice_payments_all APIP,
1787: ap_payment_hist_dists APHD,
1788: ap_invoices_all API,
1789: ap_batches_all APB,
1790: po_distributions_all POD,
1791: po_headers_all POH,

Line 2431: FROM ap_payment_hist_dists APHD,

2427: AND APIP.posted_flag = 'Y'
2428: AND APIP.set_of_books_id = l_ledger_id
2429: AND APIP.invoice_payment_id IN (
2430: SELECT APHD.invoice_payment_id
2431: FROM ap_payment_hist_dists APHD,
2432: ap_invoice_distributions_all APID,
2433: fa_mass_additions_gt FMAG
2434: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2435: AND APHD.invoice_distribution_id =

Line 2459: FROM ap_payment_hist_dists APHD,

2455: AND APIP.posted_flag = 'Y'
2456: AND APIP.set_of_books_id = l_ledger_id
2457: AND APIP.invoice_payment_id IN (
2458: SELECT APHD.invoice_payment_id
2459: FROM ap_payment_hist_dists APHD,
2460: ap_invoice_distributions_all APID,
2461: fa_mass_additions_gt FMAG
2462: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2463: AND APHD.invoice_distribution_id =