1113: from
1114: okc_k_lines_b cle
1115: , okc_k_headers_all_b chr
1116: , hz_parties hz
1117: , hz_cust_accounts hca
1118: where
1119: cle.chr_id = chr.id
1120: and chr.scs_code = 'INVESTOR'
1121: -- and chr.sts_code='NEW'
1129: from
1130: okc_k_lines_b cle
1131: , okc_k_headers_all_b chr
1132: , hz_parties hz
1133: , hz_cust_accounts hca
1134: where
1135: cle.chr_id = chr.id
1136: and chr.scs_code = 'INVESTOR'
1137: -- and chr.sts_code='NEW'