APPS.FV_FACTS_TRX_REGISTER dependencies on RA_CUSTOMER_TRX_ALL

Line 2133: ra_customer_trx_all rcth

2129: rcth.bill_to_customer_id
2130: INTO l_reference_4,
2131: l_reference_7
2132: FROM ar_transaction_history_all ara,
2133: ra_customer_trx_all rcth
2134: WHERE ara.transaction_history_id = l_ar_source_id
2135: AND ara.customer_trx_id = rcth.customer_trx_id;
2136:
2137: --fnd_file.put_line (fnd_file.log, 'l_reference_4='||l_reference_4);

Line 2176: ra_customer_trx_all rcth

2172: l_reference_7,
2173: l_reference_2
2174: FROM ra_cust_trx_line_gl_dist_all rctgl,
2175: ra_customer_trx_lines_all rctl,
2176: ra_customer_trx_all rcth
2177: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2178: AND rctl.customer_trx_line_id = rctgl.customer_trx_line_id
2179: AND rcth.customer_trx_id = rctl.customer_trx_id;
2180: ELSE

Line 2188: ra_customer_trx_all rcth

2184: INTO l_reference_4,
2185: l_reference_7,
2186: l_reference_2
2187: FROM ra_cust_trx_line_gl_dist_all rctgl,
2188: ra_customer_trx_all rcth
2189: WHERE rctgl.cust_trx_line_gl_dist_id = l_source_distribution_id_num_1
2190: AND rcth.customer_trx_id = rctgl.customer_trx_id;
2191: END IF;
2192:

Line 3355: FROM ra_customer_trx_all

3351: FROM ar_receivable_applications_all
3352: WHERE receivable_application_id = l_refer2;
3353: CURSOR Receivables_Memos_Inv IS
3354: SELECT trx_date, creation_date, created_by
3355: FROM ra_customer_trx_all
3356: WHERE customer_trx_id = l_refer2;
3357: BEGIN
3358:
3359: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5901: FROM ra_customer_trx_all rct,

5897: 'p_reimb_agree_seg_val:'||p_reimb_agree_seg_val);
5898: END IF;
5899: SELECT hzca.customer_class_code
5900: INTO l_cust_class_code
5901: FROM ra_customer_trx_all rct,
5902: hz_cust_accounts_all hzca
5903: WHERE rct.trx_number = p_reimb_agree_seg_val
5904: AND rct.set_of_books_id = g_set_of_books_id
5905: AND hzca.cust_account_id = rct.bill_to_customer_id;

Line 5944: FROM ra_customer_trx_all rct,

5940: 'p_reimb_agree_seg_val:'||p_reimb_agree_seg_val);
5941: END IF;
5942: SELECT hzca.customer_class_code
5943: INTO l_cust_class_code
5944: FROM ra_customer_trx_all rct,
5945: hz_cust_accounts_all hzca
5946: WHERE rct.trx_number = p_reimb_agree_seg_val
5947: AND rct.set_of_books_id = g_set_of_books_id
5948: AND hzca.cust_account_id = rct.bill_to_customer_id;