[Home] [Help]
5: -- global variables
6: --
7: g_adjustment_id ar_adjustments_all.adjustment_id%type;
8: g_set_of_books_id ra_customer_trx_all.set_of_books_id%type;
9: g_customer_trx_id ra_cust_trx_line_gl_dist_all.customer_trx_id%type;
10: g_cust_trx_line_id ra_cust_trx_line_gl_dist_all.customer_trx_line_id%type;
11: g_adj_ccid ar_adjustments_all.code_combination_id%type;
12: g_adj_amount ar_adjustments_all.amount%type;
13: g_adj_type ar_adjustments_all.type%type;
6: --
7: g_adjustment_id ar_adjustments_all.adjustment_id%type;
8: g_set_of_books_id ra_customer_trx_all.set_of_books_id%type;
9: g_customer_trx_id ra_cust_trx_line_gl_dist_all.customer_trx_id%type;
10: g_cust_trx_line_id ra_cust_trx_line_gl_dist_all.customer_trx_line_id%type;
11: g_adj_ccid ar_adjustments_all.code_combination_id%type;
12: g_adj_amount ar_adjustments_all.amount%type;
13: g_adj_type ar_adjustments_all.type%type;
14: g_run_id NUMBER;
357: /*
358: Bug 3140981.
359: code_combination_id included in c_mf_adjustments.
360: */
361: l_customer_trx_line_id ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE;
362:
363: Cursor c_mf_adjustments (c_sum_adr in number) Is
364: Select A.customer_trx_line_id cust_trx_line_id,
365: A.line_type line_type,
550:
551:
552:
553: -- Bug 3140981: Identify the appropriate adjustment ccid based on gl account source.
554: -- For 'Revenue on Invoice', use ccid from ra_cust_trx_line_gl_dist_all
555: -- For other gl account source, use the ccid from ar_distributions directly.
556:
557: -- ========================= FND LOG ===========================
558: psa_utils.debug_other_string(g_state_level,l_full_path, ' ccid_info(i).code_combination_id --> '