APPS.PSA_MFAR_ADJUSTMENTS dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 9: g_customer_trx_id ra_cust_trx_line_gl_dist_all.customer_trx_id%type;

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;

Line 10: g_cust_trx_line_id ra_cust_trx_line_gl_dist_all.customer_trx_line_id%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;

Line 119: From ra_cust_trx_line_gl_dist A,

115: Select B.mf_receivables_ccid mf_rec_ccid,
116: C.mf_adjustment_ccid mf_adj_ccid,
117: C.prev_mf_adjustment_ccid prev_mf_adj_ccid,
118: C.prev_cust_trx_line_id prev_cust_trx_line_id
119: From ra_cust_trx_line_gl_dist A,
120: psa_mf_trx_dist_all B,
121: psa_mf_adj_dist_all C
122: Where C.adjustment_id = g_adjustment_id
123: And A.customer_trx_id = g_customer_trx_id

Line 361: l_customer_trx_line_id ra_cust_trx_line_gl_dist_all.customer_trx_line_id%TYPE;

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,

Line 374: ra_cust_trx_line_gl_dist B,

370: 0, D.amount_due_original,
371: D.amount_due_remaining) amount_due,
372: B.percent -- panatara
373: From ra_customer_trx_lines A,
374: ra_cust_trx_line_gl_dist B,
375: psa_mf_trx_dist_all C,
376: psa_mf_balances_view D
377: Where A.customer_trx_id = g_customer_trx_id
378: and A.customer_trx_line_id = B.customer_trx_line_id

Line 450: ra_cust_trx_line_gl_dist trx_dist,

446: sum(mf_balances.amount_due_remaining)) total_amount_due,
447: sum(mf_balances.amount_due_remaining) sum_amt_due_rem
448: Into l_total_amount_due, sum_amt_due_rem
449: From ra_customer_trx_lines trx_lines,
450: ra_cust_trx_line_gl_dist trx_dist,
451: psa_mf_balances_view mf_balances
452: Where trx_lines.customer_trx_id = g_customer_trx_id
453: And trx_lines.customer_trx_line_id = trx_dist.customer_trx_line_id
454: And trx_dist.cust_trx_line_gl_dist_id = mf_balances.cust_trx_line_gl_dist_id

Line 490: ra_cust_trx_line_gl_dist B,

486: l_distr_line_count := 1;
487: ELSE
488: SELECT count(*) INTO l_distr_line_count
489: FROM ra_customer_trx_lines A,
490: ra_cust_trx_line_gl_dist B,
491: psa_mf_trx_dist_all C,
492: psa_mf_balances_view D
493: WHERE A.customer_trx_id = g_customer_trx_id
494: and A.customer_trx_line_id = B.customer_trx_line_id

Line 554: -- For 'Revenue on Invoice', use ccid from ra_cust_trx_line_gl_dist_all

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 --> '