博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

ET

Posted on 2011-05-16 14:33  ~07点07分~  阅读(131)  评论(0)    收藏  举报 
 1 select xe.event_id, 
 2        xe.application_id,
 3        xte.transaction_number,--事物处理编号
 4         xe.event_type_code,
 5        xe.event_date,
 6        xe.event_number,
 7        xe.entity_id,
 8        xe.event_status_code,
 9        xe.process_status_code--,xe.*
10   from xla_transaction_entities xte,
11        xla_events xe,
12        AR_ADJUSTMENTS_ALL AAA
13  where xe.entity_id = xte.entity_id
14    and xe.application_id = xte.application_id
15    and xte.entity_code = 'ADJUSTMENTS'
16    and xte.source_id_int_1 = aaa.adjustment_id
17    and aaa.customer_trx_id = (select customer_trx_id from  ra_customer_trx_all rct where rct.trx_number = '500940'  and rct.org_id = 204 )
18    and aaa.org_id = 204; 
19 EVENT_ID    TRANSACTION_NUMBER    EVENT_TYPE_CODE    EVENT_DATE    EVENT_NUMBER    ENTITY_ID    EVENT_STATUS_CODE    PROCESS_STATUS_CODE
20 3322476    3426    ADJ_CREATE    2011/5/12    1    3254010    U    U
21 3322477    3427    ADJ_CREATE    2011/5/12    1    3254011    U    U
22 3322478    3428    ADJ_CREATE    2011/5/12    1    3254012    U    U

select xe.event_id,

       xe.application_id,

       xte.transaction_number,--事物处理编号

       xe.event_type_code,

       xe.event_date,

       xe.event_number,

       xe.entity_id,

       xe.event_status_code,

       xe.process_status_code--,xe.*

  from xla_transaction_entities xte,

       xla_events xe,

       AR_ADJUSTMENTS_ALL AAA

 where xe.entity_id = xte.entity_id

   and xe.application_id = xte.application_id

   and xte.entity_code = 'ADJUSTMENTS'

   and xte.source_id_int_1 = aaa.adjustment_id

   and aaa.customer_trx_id = (select customer_trx_id from  ra_customer_trx_all rct where rct.trx_number = '500940'  and rct.org_id = 204 )

   and aaa.org_id = 204;

EVENT_ID

TRANSACTION_NUMBER

EVENT_TYPE_CODE

EVENT_DATE

EVENT_NUMBER

ENTITY_ID

EVENT_STATUS_CODE

PROCESS_STATUS_CODE

3322476

3426

ADJ_CREATE

2011/5/12

1

3254010

U

U

3322477

3427

ADJ_CREATE

2011/5/12

1

3254011

U

U

3322478

3428

ADJ_CREATE

2011/5/12

1

3254012

U

U