671: 'IAC',
672: 2
673: FROM
674: FA_DISTRIBUTION_HISTORY DH,
675: IGI_IAC_DET_BALANCES DD,
676: FA_ASSET_HISTORY AH,
677: FA_CATEGORY_BOOKS CB,
678: IGI_IAC_CATEGORY_BOOKS ICB,
679: FA_BOOKS BK,
793: 'GENERAL FUND',2,
794: 'NET',4) )
795: FROM
796: FA_DISTRIBUTION_HISTORY DH,
797: IGI_IAC_DET_BALANCES DD,
798: FA_ASSET_HISTORY AH,
799: FA_CATEGORY_BOOKS CB,
800: IGI_IAC_CATEGORY_BOOKS ICB,
801: FA_BOOKS BK,
870: 'COST',1,
871: 'BACKLOG',2,
872: 'NET',3)
873: FROM
874: igi_iac_det_balances db,
875: fa_distribution_history dh,
876: fa_asset_history ah,
877: igi_iac_category_books icb
878: WHERE
884: icb.book_type_code = p_book AND
885: icb.category_id = ah.category_id AND
886: db.distribution_id = dh.distribution_id AND
887: db.adjustment_id = (SELECT max(idb.adjustment_id)
888: FROM igi_iac_det_balances idb
889: WHERE idb.book_type_code = p_book AND
890: idb.asset_id = dh.asset_id AND
891: idb.distribution_id = db.distribution_id AND
892: idb.period_counter <= p_period_pc);
1025: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1026: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,
1027: (curr_adj.Operating_acct_cost - prev_adj.Operating_acct_cost) operating_acct_cost,
1028: (curr_adj.Operating_acct_backlog - prev_adj.Operating_acct_backlog) operating_acct_backlog
1029: FROM igi_iac_det_balances curr_adj,
1030: igi_iac_det_balances prev_adj
1031: WHERE curr_adj.book_type_code = cp_book
1032: AND curr_adj.asset_id = cp_asset_id
1033: AND prev_adj.book_type_code = cp_book
1026: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,
1027: (curr_adj.Operating_acct_cost - prev_adj.Operating_acct_cost) operating_acct_cost,
1028: (curr_adj.Operating_acct_backlog - prev_adj.Operating_acct_backlog) operating_acct_backlog
1029: FROM igi_iac_det_balances curr_adj,
1030: igi_iac_det_balances prev_adj
1031: WHERE curr_adj.book_type_code = cp_book
1032: AND curr_adj.asset_id = cp_asset_id
1033: AND prev_adj.book_type_code = cp_book
1034: AND prev_adj.asset_id = cp_asset_id
1048: adj.reval_reserve_backlog reval_reserve_backlog,
1049: adj.general_fund_acc general_fund,
1050: adj.operating_acct_cost operating_acct_cost,
1051: adj.operating_acct_backlog operating_acct_backlog
1052: FROM igi_iac_det_balances adj
1053: WHERE book_type_code = cp_book
1054: AND asset_id = cp_asset_id
1055: AND adjustment_id = cp_curr_adj_id
1056: AND NOT EXISTS (SELECT 'X'
1053: WHERE book_type_code = cp_book
1054: AND asset_id = cp_asset_id
1055: AND adjustment_id = cp_curr_adj_id
1056: AND NOT EXISTS (SELECT 'X'
1057: FROM igi_iac_det_balances sub_adj
1058: WHERE sub_adj.book_type_code = cp_book
1059: AND sub_adj.asset_id = cp_asset_id
1060: AND sub_adj.adjustment_id = cp_prev_adj_id
1061: AND sub_adj.distribution_id = adj.distribution_id);
1072: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1073: (adj.general_fund_acc * -1) general_fund,
1074: (adj.operating_acct_cost * -1) operating_acct_cost,
1075: (adj.operating_acct_backlog * -1) operating_acct_backlog
1076: FROM igi_iac_det_balances adj
1077: WHERE book_type_code = cp_book
1078: AND asset_id = cp_asset_id
1079: AND adjustment_id = cp_prev_adj_id
1080: AND NOT EXISTS (SELECT 'X'
1077: WHERE book_type_code = cp_book
1078: AND asset_id = cp_asset_id
1079: AND adjustment_id = cp_prev_adj_id
1080: AND NOT EXISTS (SELECT 'X'
1081: FROM igi_iac_det_balances sub_adj
1082: WHERE sub_adj.book_type_code = cp_book
1083: AND sub_adj.asset_id = cp_asset_id
1084: AND sub_adj.adjustment_id = cp_curr_adj_id
1085: AND sub_adj.distribution_id = adj.distribution_id);