DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 3077: ap_invoice_distributions aid

3073:
3074: CURSOR c_prepay_amount_remaining IS
3075: SELECT SUM(nvl(aid.prepay_amount_remaining,ail.amount))
3076: FROM ap_invoice_lines_all ail,
3077: ap_invoice_distributions aid
3078: WHERE ail.invoice_id = P_invoice_id
3079: AND aid.invoice_id = ail.invoice_id
3080: AND aid.invoice_line_number = ail.line_number
3081: AND ail.line_type_lookup_code IN ('ITEM','TAX')