DBA Data[Home] [Help]

APPS.FII_AP_INV_LINES_F_C dependencies on AP_INVOICE_PAYMENTS_ALL

Line 570: ap_invoice_payments_all aip,

566: apk.PRIMARY_KEY_CHAR1,
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

Line 590: ap_invoice_payments_all aip,

586: NVL(sum(xal.entered_cr), 0) - NVL(sum(xal.entered_dr), 0),
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

Line 1023: ap_invoice_payments_all aip,

1019: aid.invoice_line_number,
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

Line 1045: ap_invoice_payments_all aip,

1041: aid.invoice_line_number,
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