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