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