DBA Data[Home] [Help]

APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 784: FROM ap_invoice_distributions_all aid

780: l_debug_info := 'Get the total dist proration total';
781:
782: SELECT sum(aid.amount)
783: INTO l_dist_total
784: FROM ap_invoice_distributions_all aid
785: WHERE aid.invoice_id = x_corrected_invoice_id
786: AND aid.invoice_line_number = x_corrected_line_number
787: --Modified below condition for bug#10410133
788: --from " = 'ITEM' to in ('ITEM','FREIGHT','MISCELLANEOUS')"