DBA Data[Home] [Help]

APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 624: ap_invoice_distributions_s.nextval

620: round ((((x_line_amount - x_included_tax_amount) * aid.amount/p_proration_total)/
621: g_min_acct_unit) * g_min_acct_unit)
622: ) ,
623:
624: ap_invoice_distributions_s.nextval
625: FROM ap_invoice_lines ail,
626: ap_invoice_distributions aid
627: WHERE ail.invoice_id = x_corrected_invoice_id
628: AND ail.line_number = x_corrected_line_number

Line 1545: ap_invoice_distributions_s.nextval), --invoice_distribution_id

1541: SELECT g_batch_id, --batch_id
1542: x_invoice_id, --invoice_id
1543: x_invoice_line_number, --invoice_line_number
1544: NVL(x_dist_tab(i).invoice_distribution_id,
1545: ap_invoice_distributions_s.nextval), --invoice_distribution_id
1546: l_distribution_line_number, --distribution_line_number
1547: aid.line_type_lookup_code, --line_type_lookup_code
1548: --Modified ail.item_description as description for bug#10200174
1549: ail.description, --description