DBA Data[Home] [Help]

APPS.FII_AP_INV_LINES_F_C dependencies on AP_PAYMENT_HIST_DISTS

Line 571: ap_payment_hist_dists aphd,

567: sum (nvl (aphd.amount,0)),
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'

Line 1024: ap_payment_hist_dists aphd,

1020: :g_acct_or_inv_date
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''