[Home] [Help]
201: h_request_id
202: FROM fa_distribution_history dh,
203: fa_transaction_headers th,
204: fa_asset_history ah,
205: fa_adjustments_mrc_v aj,
206: fa_deprn_periods dp
207: WHERE dh.book_type_code = distribution_source_book
208: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
209: AND aj.asset_id = dh.asset_id
243: h_request_id
244: FROM fa_distribution_history dh,
245: fa_transaction_headers th,
246: fa_asset_history ah,
247: fa_adjustments_mrc_v aj,
248: fa_deprn_periods dp
249: /* SLA Changes */,
250: xla_ae_headers headers,
251: xla_ae_lines lines,
312: h_request_id
313: FROM fa_distribution_history dh,
314: fa_transaction_headers th,
315: fa_asset_history ah,
316: fa_adjustments aj,
317: fa_deprn_periods dp
318: WHERE dh.book_type_code = distribution_source_book
319: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
320: AND aj.asset_id = dh.asset_id
356: h_request_id
357: FROM fa_distribution_history dh,
358: fa_transaction_headers th,
359: fa_asset_history ah,
360: fa_adjustments aj,
361: fa_deprn_periods dp
362: /* SLA Changes */,
363: xla_ae_headers headers,
364: xla_ae_lines lines,
430: h_request_id
431: FROM fa_distribution_history dh,
432: fa_transaction_headers th,
433: fa_asset_history ah,
434: fa_adjustments_mrc_v aj,
435: fa_deprn_periods dp
436: WHERE dh.book_type_code = distribution_source_book
437: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
438: AND aj.asset_id = dh.asset_id
482: h_request_id
483: FROM fa_distribution_history dh,
484: fa_transaction_headers th,
485: fa_asset_history ah,
486: fa_adjustments_mrc_v aj,
487: fa_deprn_periods dp
488: /* SLA Changes */,
489: xla_ae_headers headers,
490: xla_ae_lines lines,
560: h_request_id
561: FROM fa_distribution_history dh,
562: fa_transaction_headers th,
563: fa_asset_history ah,
564: fa_adjustments aj,
565: fa_deprn_periods dp
566:
567: WHERE dh.book_type_code = distribution_source_book
568: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
613: h_request_id
614: FROM fa_distribution_history dh,
615: fa_transaction_headers th,
616: fa_asset_history ah,
617: fa_adjustments aj,
618: fa_deprn_periods dp
619: /* SLA Changes */,
620: xla_ae_headers headers,
621: xla_ae_lines lines,
841: aj.source_type_code,
842: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
843: aj.adjustment_amount),
844: h_request_id
845: FROM fa_adjustments_mrc_v aj,
846: fa_books_mrc_v bk,
847: fa_group_asset_default gad,
848: fa_deprn_periods dp
849: WHERE bk.asset_id = aj.asset_id
891: aj.source_type_code,
892: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
893: aj.adjustment_amount),
894: h_request_id
895: FROM fa_adjustments_mrc_v aj,
896: fa_books_mrc_v bk,
897: fa_group_asset_default gad,
898: fa_deprn_periods dp
899: /* SLA Changes */,
966: aj.source_type_code,
967: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
968: aj.adjustment_amount),
969: h_request_id
970: FROM fa_adjustments aj,
971: fa_books bk,
972: fa_group_asset_default gad,
973: fa_deprn_periods dp
974: WHERE bk.asset_id = aj.asset_id
1016: aj.source_type_code,
1017: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
1018: aj.adjustment_amount),
1019: h_request_id
1020: FROM fa_adjustments aj,
1021: fa_books bk,
1022: fa_group_asset_default gad,
1023: fa_deprn_periods dp
1024:
2434: fa_distribution_history dh,
2435: fa_asset_history ah,
2436: fa_deprn_detail_mrc_v dd,
2437: fa_deprn_periods_mrc_v dp,
2438: fa_adjustments_mrc_v adj
2439: WHERE dh.book_type_code = distribution_source_book
2440: AND ah.asset_id = dd.asset_id
2441: AND ah.asset_type IN ('CAPITALIZED', 'CIP')
2442: AND ah.date_effective < nvl(dh.date_ineffective, SYSDATE)
2515: fa_distribution_history dh,
2516: fa_asset_history ah,
2517: fa_deprn_detail dd,
2518: fa_deprn_periods dp,
2519: fa_adjustments adj
2520: WHERE dh.book_type_code = distribution_source_book
2521: AND ah.asset_id = dd.asset_id
2522: AND ah.asset_type IN ('CAPITALIZED', 'CIP')
2523: AND ah.date_effective < nvl(dh.date_ineffective, SYSDATE)