166: FROM ra_customer_trx RCT
167: ,ra_cust_trx_line_gl_dist_all RCTD
168: ,ra_cust_trx_types_all RCTT
169: ,hz_cust_accounts HCA
170: ,hz_parties HZP
171: ,gl_code_combinations GCC
172: ,ar_adjustments_all ARA
173: ,ar_distributions_all ARD
174: WHERE RCT.initial_customer_trx_id = p_customer_trx_id