DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 3126: ap_invoice_distributions aid

3122:
3123: CURSOR c_prepay_amount_remaining IS
3124: SELECT SUM(nvl(aid.prepay_amount_remaining,ail.amount))
3125: FROM ap_invoice_lines_all ail,
3126: ap_invoice_distributions aid
3127: WHERE ail.invoice_id = P_invoice_id
3128: AND aid.invoice_id = ail.invoice_id
3129: AND aid.invoice_line_number = ail.line_number
3130: AND ail.line_type_lookup_code IN ('ITEM','TAX')