APPS.PSA_MFAR_ADJUSTMENTS dependencies on RA_CUSTOMER_TRX_LINES

Line 373: From ra_customer_trx_lines A,

369: decode (c_sum_adr,
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

Line 449: From ra_customer_trx_lines trx_lines,

445: Select decode (sum(mf_balances.amount_due_remaining), 0, sum(mf_balances.amount_due_original),
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

Line 489: FROM ra_customer_trx_lines A,

485: IF (l_customer_trx_line_id IS NOT NULL) THEN
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

Line 777: FROM ra_customer_trx_lines

773:
774: CURSOR c_tax_freight
775: IS
776: SELECT line_type
777: FROM ra_customer_trx_lines
778: WHERE line_type = p_adjustment_type
779: AND rownum = 1;
780:
781: l_line_type_rec c_tax_freight%rowtype;