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.FII_AP_INV_LINES_F_C dependencies on AP_PAYMENT_HISTORY_ALL

Line 572: ap_payment_history_all aph

568: sum(nvl(aphd.paid_base_amount,0))
569: FROM fii_ap_tmp_line_pk apk,
570: ap_invoice_payments_all aip,
571: ap_payment_hist_dists aphd,
572: ap_payment_history_all aph
573: WHERE apk.PRIMARY_KEY1 = aip.invoice_id
574: AND aip.invoice_payment_id = aphd.invoice_payment_id
575: AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'
576: AND aphd.invoice_distribution_id = apk.PRIMARY_KEY3

Line 591: -- ap_payment_history_all aph,

587: NVL(sum(NVL(xal.accounted_cr, xal.entered_cr)), 0) -
588: NVL(sum(NVL(xal.accounted_dr, xal.entered_dr)), 0)
589: FROM fii_ap_tmp_line_pk apk,
590: ap_invoice_payments_all aip,
591: -- ap_payment_history_all aph,
592: xla_ae_lines xal,
593: xla_ae_headers xah
594: WHERE apk.PRIMARY_KEY1 = aip.invoice_id
595: AND aip.invoice_payment_id = xal.Upg_Tax_Reference_ID3

Line 1025: ap_payment_history_all aph

1021: FROM ap_invoice_distributions_all aid,
1022: ap_invoices_all ai,
1023: ap_invoice_payments_all aip,
1024: ap_payment_hist_dists aphd,
1025: ap_payment_history_all aph
1026: WHERE aid.invoice_id = ai.invoice_id
1027: AND aid.invoice_id = aip.invoice_id
1028: AND aid.posted_flag = ''Y''
1029: AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 1046: -- ap_payment_history_all aph,

1042: :g_acct_or_inv_date
1043: FROM ap_invoice_distributions_all aid,
1044: ap_invoices_all ai,
1045: ap_invoice_payments_all aip,
1046: -- ap_payment_history_all aph,
1047: xla_ae_lines xal,
1048: xla_ae_headers xah
1049: WHERE aid.invoice_id = ai.invoice_id
1050: AND aid.invoice_id = aip.invoice_id