[Home] [Help]
79: 1
80: FROM
81: FA_DISTRIBUTION_HISTORY DH,
82: FA_TRANSACTION_HEADERS TH,
83: FA_ASSET_HISTORY AH,
84: FA_ADJUSTMENTS AJ
85:
86: /* SLA Changes */
87: ,xla_ae_headers headers
470: 1
471: FROM
472: FA_DISTRIBUTION_HISTORY DH,
473: FA_CATEGORY_BOOKS CB,
474: FA_ASSET_HISTORY AH,
475: FA_DEPRN_DETAIL DD
476: WHERE
477: NOT EXISTS (SELECT ASSET_ID
478: FROM IGI_IAC_BALANCES_REPORT
566: 1
567: FROM
568: FA_DISTRIBUTION_HISTORY DH,
569: FA_DEPRN_DETAIL DD,
570: FA_ASSET_HISTORY AH,
571: FA_CATEGORY_BOOKS CB,
572: FA_BOOKS BK
573: WHERE
574: DH.Book_Type_Code = p_Distribution_Source_Book AND
653: 2
654: FROM
655: FA_DISTRIBUTION_HISTORY DH,
656: IGI_IAC_DET_BALANCES DD,
657: FA_ASSET_HISTORY AH,
658: FA_CATEGORY_BOOKS CB,
659: IGI_IAC_CATEGORY_BOOKS ICB,
660: FA_BOOKS BK,
661: IGI_IAC_TRANSACTION_HEADERS ITH
775: 'NET',4) )
776: FROM
777: FA_DISTRIBUTION_HISTORY DH,
778: IGI_IAC_DET_BALANCES DD,
779: FA_ASSET_HISTORY AH,
780: FA_CATEGORY_BOOKS CB,
781: IGI_IAC_CATEGORY_BOOKS ICB,
782: FA_BOOKS BK,
783: IGI_IAC_TRANSACTION_HEADERS ITH
853: 'NET',3)
854: FROM
855: igi_iac_det_balances db,
856: fa_distribution_history dh,
857: fa_asset_history ah,
858: igi_iac_category_books icb
859: WHERE
860: dh.book_type_code = p_book AND
861: nvl(dh.date_ineffective, p_earliest_date-1) > p_earliest_date AND
920: 1
921: FROM
922: FA_CATEGORY_BOOKS CB,
923: FA_DISTRIBUTION_HISTORY DH,
924: FA_ASSET_HISTORY AH,
925: FA_DEPRN_DETAIL DD,
926: FA_DEPRN_PERIODS DP
927: WHERE
928: DH.Book_Type_Code = p_Distribution_Source_Book AND
1069: CURSOR c_get_category(cp_book fa_books.book_type_code%TYPE,
1070: cp_asset_id fa_additions.asset_id%TYPE,
1071: cp_transaction_id igi_iac_transaction_headers.transaction_header_id%TYPE) IS
1072: SELECT ah.category_id
1073: FROM fa_asset_history ah,
1074: fa_transaction_headers th
1075: WHERE ah.asset_id = cp_asset_id
1076: AND th.transaction_header_id = cp_transaction_id
1077: AND th.book_type_code = cp_book