[Home] [Help]
98: 1
99: FROM
100: FA_DISTRIBUTION_HISTORY DH,
101: FA_TRANSACTION_HEADERS TH,
102: FA_ASSET_HISTORY AH,
103: FA_ADJUSTMENTS AJ
104:
105: /* SLA Changes */
106: ,xla_ae_headers headers
489: 1
490: FROM
491: FA_DISTRIBUTION_HISTORY DH,
492: FA_CATEGORY_BOOKS CB,
493: FA_ASSET_HISTORY AH,
494: FA_DEPRN_DETAIL DD
495: WHERE
496: NOT EXISTS (SELECT ASSET_ID
497: FROM IGI_IAC_BALANCES_REPORT
585: 1
586: FROM
587: FA_DISTRIBUTION_HISTORY DH,
588: FA_DEPRN_DETAIL DD,
589: FA_ASSET_HISTORY AH,
590: FA_CATEGORY_BOOKS CB,
591: FA_BOOKS BK
592: WHERE
593: DH.Book_Type_Code = p_Distribution_Source_Book AND
672: 2
673: FROM
674: FA_DISTRIBUTION_HISTORY DH,
675: IGI_IAC_DET_BALANCES DD,
676: FA_ASSET_HISTORY AH,
677: FA_CATEGORY_BOOKS CB,
678: IGI_IAC_CATEGORY_BOOKS ICB,
679: FA_BOOKS BK,
680: IGI_IAC_TRANSACTION_HEADERS ITH
794: 'NET',4) )
795: FROM
796: FA_DISTRIBUTION_HISTORY DH,
797: IGI_IAC_DET_BALANCES DD,
798: FA_ASSET_HISTORY AH,
799: FA_CATEGORY_BOOKS CB,
800: IGI_IAC_CATEGORY_BOOKS ICB,
801: FA_BOOKS BK,
802: IGI_IAC_TRANSACTION_HEADERS ITH
872: 'NET',3)
873: FROM
874: igi_iac_det_balances db,
875: fa_distribution_history dh,
876: fa_asset_history ah,
877: igi_iac_category_books icb
878: WHERE
879: dh.book_type_code = p_book AND
880: nvl(dh.date_ineffective, p_earliest_date-1) > p_earliest_date AND
939: 1
940: FROM
941: FA_CATEGORY_BOOKS CB,
942: FA_DISTRIBUTION_HISTORY DH,
943: FA_ASSET_HISTORY AH,
944: FA_DEPRN_DETAIL DD,
945: FA_DEPRN_PERIODS DP
946: WHERE
947: DH.Book_Type_Code = p_Distribution_Source_Book AND
1088: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1089: cp_asset_id fa_additions.asset_id%TYPE,
1090: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1091: SELECT ah.category_id
1092: FROM fa_asset_history ah,
1093: fa_transaction_headers th
1094: WHERE ah.asset_id = cp_asset_id
1095: AND th.transaction_header_id = cp_transaction_id
1096: AND th.book_type_code = cp_book