DBA Data[Home] [Help]

APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 610: ap_invoice_distributions_s.nextval

606: round ((((x_line_amount - x_included_tax_amount) * aid.amount/p_proration_total)/
607: g_min_acct_unit) * g_min_acct_unit)
608: ) ,
609:
610: ap_invoice_distributions_s.nextval
611: FROM ap_invoice_lines ail,
612: ap_invoice_distributions aid
613: WHERE ail.invoice_id = x_corrected_invoice_id
614: AND ail.line_number = x_corrected_line_number

Line 1511: ap_invoice_distributions_s.nextval), --invoice_distribution_id

1507: SELECT g_batch_id, --batch_id
1508: x_invoice_id, --invoice_id
1509: x_invoice_line_number, --invoice_line_number
1510: NVL(x_dist_tab(i).invoice_distribution_id,
1511: ap_invoice_distributions_s.nextval), --invoice_distribution_id
1512: l_distribution_line_number, --distribution_line_number
1513: aid.line_type_lookup_code, --line_type_lookup_code
1514: ail.item_description, --description
1515: 'DIST_CORRECTION', --dist_match_type