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,
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,
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
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,