SELECT ct.org_id

       ,ct.attribute1 bu_id --核算主体编号

       ,ct.attribute2 dept_id --部门编号

       ,hca.account_number

       ,hp.party_name --收单方

       ,ct.attribute3 --项目编号

       ,pa.long_name --项目

       ,to_char(ct.trx_date) trx_date

       ,to_char(gd.gl_date) gl_date

       ,ct.trx_number --编号

       ,rc.name --事务处理类型

       ,ct.invoice_currency_code --币种

       ,ct.exchange_rate --汇率

       ,hp.attribute2 group_customer --集团客户

       ,ct.attribute8 final_customer_code --最终客户

       ,zl.tax_rate_code tax_rate_code --税率名称

       ,zl.tax_amt       tax_amt --税额

       ,ct.attribute15 outside_system --外围系统ID

  FROM ra_cust_trx_types_all        rc,

       ar.ra_customer_trx_all       ct,

       ra_cust_trx_types_all        ctt,

       ra_cust_trx_line_gl_dist_all gd,

       hz_cust_accounts             hca,

       hz_parties                   hp,

       hz_cust_site_uses_all        hcs,

       pa_projects_all              pa,

       ra_customer_trx_lines_all    ctl,

       zx_lines                     zl

 WHERE rc.org_id = ct.org_id

   AND ctl.customer_trx_id = ct.customer_trx_id

   AND ctl.org_id = ct.org_id

   AND rc.cust_trx_type_id = ct.cust_trx_type_id

   AND ct.customer_trx_id = gd.customer_trx_id

   and ctl.tax_line_id = zl.tax_line_id

   AND 'REC' = gd.account_class

   AND 'Y' = gd.latest_rec_flag

   AND ct.cust_trx_type_id = ctt.cust_trx_type_id

   AND ctt.type <> 'BR'

   AND ctt.org_id = ct.org_id

   AND ct.bill_to_customer_id = hca.cust_account_id

   AND hca.party_id = hp.party_id

   AND ct.bill_to_site_use_id = hcs.site_use_id

   AND ct.org_id = pa.org_id(+)

   AND ct.attribute3 = pa.segment1(+);