DBA Data[Home] [Help]

APPS.PSA_MFAR_RECEIPTS dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 702: ra_cust_trx_line_gl_dist_all trx_dist,

698: -- column below changed by RM for 1604281
699: decode (sum_adr, 0, mf_balances.amount_due_original,
700: mf_balances.amount_due_remaining) amount_due
701: From ra_customer_trx_lines_all trx_line,
702: ra_cust_trx_line_gl_dist_all trx_dist,
703: psa_mf_trx_dist_all mf_trx_dist,
704: psa_mf_balances_view mf_balances
705: Where trx_line.customer_trx_id = p_cust_trx_id
706: And mf_balances.customer_trx_id = p_cust_trx_id

Line 721: ra_cust_trx_line_gl_dist_all trx_dist

717: Select trx_dist.code_combination_id rev_ccid,
718: trx_dist.cust_trx_line_gl_dist_id trx_line_dist_id
719: From ra_customer_trx_all trx,
720: ra_customer_trx_lines_all trx_line,
721: ra_cust_trx_line_gl_dist_all trx_dist
722: Where trx.customer_trx_id = p_cust_trx_id
723: And trx.customer_trx_id = trx_line.customer_trx_id
724: And trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id
725: And trx_dist.account_class = 'REV';

Line 898: ra_cust_trx_line_gl_dist_all trx_dist,

894: sum(mf_balances.amount_due_remaining)) sum_amt_due_rem
895: INTO l_total_amount_due,
896: sum_amt_due_rem
897: FROM ra_customer_trx_lines_all trx_line,
898: ra_cust_trx_line_gl_dist_all trx_dist,
899: psa_mf_balances_view mf_balances
900: WHERE trx_line.customer_trx_id = p_cust_trx_id
901: AND mf_balances.customer_trx_id = p_cust_trx_id
902: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id

Line 1523: ra_cust_trx_line_gl_dist_all trx_dist,

1519: sum(mf_balances.amount_due_original) sum_amt_due_rem
1520: INTO l_total_amount_due,
1521: sum_amt_due_rem
1522: FROM ra_customer_trx_lines_all trx_line,
1523: ra_cust_trx_line_gl_dist_all trx_dist,
1524: psa_mf_balances_view mf_balances
1525: WHERE trx_line.customer_trx_id = p_cust_trx_id
1526: AND mf_balances.customer_trx_id = p_cust_trx_id
1527: AND trx_line.customer_trx_line_id = trx_dist.customer_trx_line_id