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