DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICES_UTILITY_PKG

Line 77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),

73: V.vendor_name,
74: V.segment1,
75: I.invoice_currency_code,
76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,

Line 78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),

74: V.segment1,
75: I.invoice_currency_code,
76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,

Line 79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),

75: I.invoice_currency_code,
76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code

Line 80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),

76: I.invoice_amount,
77: ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
78: I.invoice_amount - ap_invoices_utility_pkg.get_prepaid_amount(I.invoice_id),
79: ap_invoices_utility_pkg.get_prepay_amount_remaining(P.invoice_id),
80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code
84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,