[Home] [Help]
105: bc.REVAL_RSV_RETIRED_LOSS_ACCT
106: FROM xla_events_gt ctlgd,
107: fa_deprn_periods dp,
108: fa_book_controls bc ,
109: FA_TRANSACTION_HEADERS th
110: WHERE ctlgd.entity_code = 'TRANSACTIONS'
111: AND ctlgd.event_type_code in ('ADDITIONS', 'CIP_ADDITIONS',
112: 'ADJUSTMENTS', 'CIP_ADJUSTMENTS',
113: 'CAPITALIZATION', 'REVERSE_CAPITALIZATION',
327: fa_asset_history ah,
328: fa_book_controls bc,
329: fa_category_books cb,
330: gl_ledgers le,
331: fa_transaction_headers th,
332: xla_events_gt ctlgd
333: where ctlgd.entity_code = 'TRANSACTIONS'
334: AND ctlgd.event_type_code in ('ADDITIONS', 'CIP_ADDITIONS',
335: 'ADJUSTMENTS', 'CIP_ADJUSTMENTS',
436: CIP_CLEARING_ACCT,
437: CIP_COST_ACCT,
438: DEPRN_RESERVE_ACCT,
439: REVAL_RESERVE_ACCT )
440: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_U1) */ ctlgd.EVENT_ID ,
441: ctlgd.event_type_code ,
442: th.transaction_header_id ,
443: nvl(th.member_transaction_header_id,
444: th.transaction_header_id) ,
472: fa_asset_history ah,
473: fa_book_controls bc,
474: fa_category_books cb,
475: gl_ledgers le,
476: fa_transaction_headers th,
477: fa_trx_references trx,
478: xla_events_gt ctlgd
479: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'
480: AND ctlgd.event_type_code in ('SOURCE_LINE_TRANSFERS',
532: CIP_CLEARING_ACCT,
533: CIP_COST_ACCT,
534: DEPRN_RESERVE_ACCT,
535: REVAL_RESERVE_ACCT )
536: select /*+ leading(ctgld) index(th, FA_TRANSACTION_HEADERS_N7) */ ctlgd.EVENT_ID ,
537: ctlgd.event_type_code ,
538: th.transaction_header_id ,
539: nvl(th.member_transaction_header_id,
540: th.transaction_header_id) ,
568: fa_asset_history ah,
569: fa_book_controls bc,
570: fa_category_books cb,
571: gl_ledgers le,
572: fa_transaction_headers th,
573: fa_trx_references trx,
574: xla_events_gt ctlgd
575: where ctlgd.entity_code = 'INTER_ASSET_TRANSACTIONS'
576: AND ctlgd.event_type_code in ('SOURCE_LINE_TRANSFERS',