APPS.FV_FACTS_TRX_REGISTER dependencies on RA_CUSTOMER_TRX_ALL

Line 2053: ra_customer_trx_all rcth

2049: rcth.bill_to_customer_id
2050: INTO l_reference_4,
2051: l_reference_7
2052: FROM ar_transaction_history_all ara,
2053: ra_customer_trx_all rcth
2054: WHERE ara.transaction_history_id = l_ar_source_id
2055: AND ara.customer_trx_id = rcth.customer_trx_id;
2056:
2057: fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

Line 2096: ra_customer_trx_all rcth

2092: l_reference_7,
2093: l_reference_2
2094: FROM ra_cust_trx_line_gl_dist_all rctgl,
2095: ra_customer_trx_lines_all rctl,
2096: ra_customer_trx_all rcth
2097: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2098: AND rctl.customer_trx_line_id = rctgl.customer_trx_line_id
2099: AND rcth.customer_trx_id = rctl.customer_trx_id;
2100: ELSE

Line 2108: ra_customer_trx_all rcth

2104: INTO l_reference_4,
2105: l_reference_7,
2106: l_reference_2
2107: FROM ra_cust_trx_line_gl_dist_all rctgl,
2108: ra_customer_trx_all rcth
2109: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2110: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2111: END IF;
2112:

Line 3141: FROM ra_customer_trx_all

3137: FROM ar_receivable_applications_all
3138: WHERE receivable_application_id = l_refer2;
3139: CURSOR Receivables_Memos_Inv IS
3140: SELECT trx_date, creation_date, created_by
3141: FROM ra_customer_trx_all
3142: WHERE customer_trx_id = l_refer2;
3143: BEGIN
3144: fnd_file.put_line (fnd_file.log, 'BEGIN GET_DOC_INFO');
3145: fnd_file.put_line (fnd_file.log, 'p_je_header_id='||p_je_header_id);