92: 1
93: FROM
94: FA_DISTRIBUTION_HISTORY DH,
95: FA_TRANSACTION_HEADERS TH,
96: FA_ASSET_HISTORY AH,
97: FA_ADJUSTMENTS AJ
98:
99: /* SLA Changes */
100: ,xla_ae_headers headers
483: 1
484: FROM
485: FA_DISTRIBUTION_HISTORY DH,
486: FA_CATEGORY_BOOKS CB,
487: FA_ASSET_HISTORY AH,
488: FA_DEPRN_DETAIL DD
489: WHERE
490: NOT EXISTS (SELECT ASSET_ID
491: FROM IGI_IAC_BALANCES_REPORT
579: 1
580: FROM
581: FA_DISTRIBUTION_HISTORY DH,
582: FA_DEPRN_DETAIL DD,
583: FA_ASSET_HISTORY AH,
584: FA_CATEGORY_BOOKS CB,
585: FA_BOOKS BK
586: WHERE
587: DH.Book_Type_Code = p_Distribution_Source_Book AND
666: 2
667: FROM
668: FA_DISTRIBUTION_HISTORY DH,
669: IGI_IAC_DET_BALANCES DD,
670: FA_ASSET_HISTORY AH,
671: FA_CATEGORY_BOOKS CB,
672: IGI_IAC_CATEGORY_BOOKS ICB,
673: FA_BOOKS BK,
674: IGI_IAC_TRANSACTION_HEADERS ITH
788: 'NET',4) )
789: FROM
790: FA_DISTRIBUTION_HISTORY DH,
791: IGI_IAC_DET_BALANCES DD,
792: FA_ASSET_HISTORY AH,
793: FA_CATEGORY_BOOKS CB,
794: IGI_IAC_CATEGORY_BOOKS ICB,
795: FA_BOOKS BK,
796: IGI_IAC_TRANSACTION_HEADERS ITH
866: 'NET',3)
867: FROM
868: igi_iac_det_balances db,
869: fa_distribution_history dh,
870: fa_asset_history ah,
871: igi_iac_category_books icb
872: WHERE
873: dh.book_type_code = p_book AND
874: nvl(dh.date_ineffective, p_earliest_date-1) > p_earliest_date AND
933: 1
934: FROM
935: FA_CATEGORY_BOOKS CB,
936: FA_DISTRIBUTION_HISTORY DH,
937: FA_ASSET_HISTORY AH,
938: FA_DEPRN_DETAIL DD,
939: FA_DEPRN_PERIODS DP
940: WHERE
941: DH.Book_Type_Code = p_Distribution_Source_Book AND
1082: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1083: cp_asset_id fa_additions.asset_id%TYPE,
1084: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1085: SELECT ah.category_id
1086: FROM fa_asset_history ah,
1087: fa_transaction_headers th
1088: WHERE ah.asset_id = cp_asset_id
1089: AND th.transaction_header_id = cp_transaction_id
1090: AND th.book_type_code = cp_book