17: SELECT
18: DISTINCT ctl.customer_trx_id,
19: ct.trx_number
20: FROM
21: ra_customer_trx ct,
22: ra_customer_trx_lines ctl
23: WHERE
24: ctl.autorule_complete_flag = 'N'
25: AND ct.customer_trx_id = ctl.customer_trx_id
18: DISTINCT ctl.customer_trx_id,
19: ct.trx_number
20: FROM
21: ra_customer_trx ct,
22: ra_customer_trx_lines ctl
23: WHERE
24: ctl.autorule_complete_flag = 'N'
25: AND ct.customer_trx_id = ctl.customer_trx_id
26: AND ct.complete_flag = 'Y';