eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_RXI_I_WRAP_ASSET_BAL dependencies on FA_BOOKS

Line 636: l_life_in_months fa_Books.life_in_months%TYPE;

632: l_deprn_total NUMBER;
633: l_asset_cat_id NUMBER(15);
634: l_asset_tag fa_additions.tag_number%TYPE;
635: l_serial_number fa_additions.serial_number%TYPE;
636: l_life_in_months fa_Books.life_in_months%TYPE;
637: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
638: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
639: l_depreciation_method fa_Books.deprn_method_code%TYPE;
640: l_location_id fa_distribution_history.location_id%TYPE;

Line 637: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

633: l_asset_cat_id NUMBER(15);
634: l_asset_tag fa_additions.tag_number%TYPE;
635: l_serial_number fa_additions.serial_number%TYPE;
636: l_life_in_months fa_Books.life_in_months%TYPE;
637: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
638: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
639: l_depreciation_method fa_Books.deprn_method_code%TYPE;
640: l_location_id fa_distribution_history.location_id%TYPE;
641: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 639: l_depreciation_method fa_Books.deprn_method_code%TYPE;

635: l_serial_number fa_additions.serial_number%TYPE;
636: l_life_in_months fa_Books.life_in_months%TYPE;
637: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
638: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
639: l_depreciation_method fa_Books.deprn_method_code%TYPE;
640: l_location_id fa_distribution_history.location_id%TYPE;
641: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
642: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
643: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 682: fa_Books bk,

678: sum(nvl(dd.deprn_reserve,0)) Acc_Deprn_Normal,
679: 0 Acc_Deprn_backlog,
680: sum(nvl(dd.deprn_reserve,0)) Acc_Deprn_Total
681: FROM fa_additions ad,
682: fa_Books bk,
683: fa_distribution_history dh,
684: fa_deprn_Detail dd,
685: gl_code_combinations cc,
686: fa_categories cf,

Line 715: FROM fa_books ifb

711: WHERE asset_id = bk.asset_id
712: AND book_type_code = bk.book_type_code
713: AND period_counter <= fdp.period_counter )
714: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
715: FROM fa_books ifb
716: WHERE ifb.book_type_code = bk.book_type_code
717: AND ifb.asset_id = bk.asset_id
718: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
719: AND bk.asset_id not in

Line 760: fa_Books bk ,

756: sum(nvl(id.Deprn_Reserve + dd.deprn_Reserve, 0)) Acc_Deprn_Normal ,
757: sum(nvl(id.Deprn_Reserve_backlog, 0) ) Acc_Deprn_Backlog ,
758: sum(nvl(id.Deprn_Reserve+dd.deprn_reserve+id.deprn_Reserve_backlog, 0)) Acc_Deprn_Total
759: FROM fa_additions ad ,
760: fa_Books bk ,
761: fa_distribution_history dh,
762: fa_deprn_Detail dd ,
763: igi_iac_det_balances id,
764: igi_iac_fa_deprn ifd,

Line 796: FROM fa_books ifb

792: AND book_type_code = bk.book_type_code
793: AND ids.distribution_id = dd.distribution_id
794: AND period_counter <= fdp.period_counter )
795: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
796: FROM fa_books ifb
797: WHERE ifb.book_type_code = bk.book_type_code
798: AND ifb.asset_id = bk.asset_id
799: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
800: AND dh.distribution_id = id.distribution_id

Line 1029: l_life_in_months fa_Books.life_in_months%TYPE;

1025: l_asset_tag fa_additions.tag_number%TYPE;
1026: l_parent_id fa_additions.parent_asset_id%TYPE;
1027: l_parent_no VARCHAR2(15);
1028: l_serial_number fa_additions.serial_number%TYPE;
1029: l_life_in_months fa_Books.life_in_months%TYPE;
1030: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1031: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1033: l_location_id fa_distribution_history.location_id%TYPE;

Line 1030: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

1026: l_parent_id fa_additions.parent_asset_id%TYPE;
1027: l_parent_no VARCHAR2(15);
1028: l_serial_number fa_additions.serial_number%TYPE;
1029: l_life_in_months fa_Books.life_in_months%TYPE;
1030: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1031: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1033: l_location_id fa_distribution_history.location_id%TYPE;
1034: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;

1028: l_serial_number fa_additions.serial_number%TYPE;
1029: l_life_in_months fa_Books.life_in_months%TYPE;
1030: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1031: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1032: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1033: l_location_id fa_distribution_history.location_id%TYPE;
1034: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1035: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1036: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 1087: fa_Books bk,

1083: sum(nvl(dd.deprn_reserve,0)) Acc_Deprn_Normal,
1084: 0 Acc_Deprn_backlog,
1085: sum(nvl(dd.deprn_reserve,0)) Acc_Deprn_Total
1086: FROM fa_additions ad,
1087: fa_Books bk,
1088: fa_distribution_history dh,
1089: fa_deprn_Detail dd,
1090: gl_code_combinations cc,
1091: fa_categories cf,

Line 1127: FROM fa_books ifb

1123: WHERE asset_id = bk.asset_id
1124: AND book_type_code = bk.book_type_code
1125: AND period_counter <= fdp.period_counter )
1126: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
1127: FROM fa_books ifb
1128: WHERE ifb.book_type_code = bk.book_type_code
1129: AND ifb.asset_id = bk.asset_id
1130: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
1131: AND ' || cost_ctr_seg_no || ' between nvl( :v_from_cc, ' || cost_ctr_seg_no || ' )

Line 1184: fa_Books bk ,

1180: sum(nvl(id.Deprn_Reserve + dd.deprn_Reserve, 0)) Acc_Deprn_Normal ,
1181: sum(nvl(id.Deprn_Reserve_backlog, 0) ) Acc_Deprn_Backlog ,
1182: sum(nvl(id.Deprn_Reserve+dd.deprn_reserve+id.deprn_Reserve_backlog, 0)) Acc_Deprn_Total
1183: FROM fa_additions ad ,
1184: fa_Books bk ,
1185: fa_distribution_history dh,
1186: fa_deprn_Detail dd ,
1187: igi_iac_det_balances id,
1188: igi_iac_fa_deprn ifd,

Line 1222: FROM fa_books ifb

1218: AND ids.book_type_code = bk.book_type_code
1219: AND ids.distribution_id = dd.distribution_id
1220: AND ids.period_counter <= fdp.period_counter )
1221: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
1222: FROM fa_books ifb
1223: WHERE ifb.book_type_code = bk.book_type_code
1224: AND ifb.asset_id = bk.asset_id
1225: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
1226: AND id.distribution_id = dd.distribution_id

Line 1546: l_life_in_months fa_Books.life_in_months%TYPE;

1542: l_oper_exp_net NUMBER;
1543: l_asset_cat_id NUMBER(15);
1544: l_asset_tag fa_additions.tag_number%TYPE;
1545: l_serial_number fa_additions.serial_number%TYPE;
1546: l_life_in_months fa_Books.life_in_months%TYPE;
1547: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1548: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1550: l_location_id fa_distribution_history.location_id%TYPE;

Line 1547: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

1543: l_asset_cat_id NUMBER(15);
1544: l_asset_tag fa_additions.tag_number%TYPE;
1545: l_serial_number fa_additions.serial_number%TYPE;
1546: l_life_in_months fa_Books.life_in_months%TYPE;
1547: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1548: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1550: l_location_id fa_distribution_history.location_id%TYPE;
1551: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;

1545: l_serial_number fa_additions.serial_number%TYPE;
1546: l_life_in_months fa_Books.life_in_months%TYPE;
1547: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1548: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1549: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1550: l_location_id fa_distribution_history.location_id%TYPE;
1551: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1552: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1553: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 1592: fa_Books bk,

1588: 0 Oper_Acct_Cost,
1589: 0 Oper_Acct_Backlog,
1590: 0 Oper_Acct_Net
1591: FROM fa_additions ad,
1592: fa_Books bk,
1593: fa_distribution_history dh,
1594: fa_deprn_Detail dd,
1595: gl_code_combinations cc,
1596: fa_categories cf,

Line 1611: FROM fa_books ifb

1607: AND fdp.book_type_code = bk.book_type_code
1608: AND fdp.period_counter = :v_period
1609: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
1610: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
1611: FROM fa_books ifb
1612: WHERE ifb.book_type_code = bk.book_type_code
1613: AND ifb.asset_id = bk.asset_id
1614: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
1615: AND dd.asset_id = bk.asset_id

Line 1668: fa_Books bk ,

1664: sum(nvl(id.operating_acct_cost * -1,0)) Oper_Acct_Cost,
1665: sum(nvl(id.operating_acct_backlog * -1 ,0)) Oper_Acct_Backlog,
1666: sum(nvl(id.operating_acct_net * -1 ,0)) Oper_Acct_Net
1667: FROM fa_additions ad ,
1668: fa_Books bk ,
1669: fa_distribution_history dh,
1670: fa_deprn_Detail dd ,
1671: igi_iac_det_balances id ,
1672: gl_code_combinations cc,

Line 1689: FROM fa_books ifb

1685: AND fdp.book_type_code = bk.book_type_code
1686: AND fdp.period_counter = :v_period1
1687: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
1688: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
1689: FROM fa_books ifb
1690: WHERE ifb.book_type_code = bk.book_type_code
1691: AND ifb.asset_id = bk.asset_id
1692: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
1693: AND dh.book_type_Code = bk.book_type_code

Line 1922: l_life_in_months fa_Books.life_in_months%TYPE;

1918: l_asset_tag fa_additions.tag_number%TYPE;
1919: l_parent_id fa_additions.parent_asset_id%TYPE;
1920: l_parent_no VARCHAR2(15);
1921: l_serial_number fa_additions.serial_number%TYPE;
1922: l_life_in_months fa_Books.life_in_months%TYPE;
1923: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1924: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1926: l_location_id fa_distribution_history.location_id%TYPE;

Line 1923: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

1919: l_parent_id fa_additions.parent_asset_id%TYPE;
1920: l_parent_no VARCHAR2(15);
1921: l_serial_number fa_additions.serial_number%TYPE;
1922: l_life_in_months fa_Books.life_in_months%TYPE;
1923: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1924: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1926: l_location_id fa_distribution_history.location_id%TYPE;
1927: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;

1921: l_serial_number fa_additions.serial_number%TYPE;
1922: l_life_in_months fa_Books.life_in_months%TYPE;
1923: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
1924: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
1925: l_depreciation_method fa_Books.deprn_method_code%TYPE;
1926: l_location_id fa_distribution_history.location_id%TYPE;
1927: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
1928: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
1929: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 1980: fa_Books bk,

1976: 0 Oper_Acct_Cost,
1977: 0 Oper_Acct_Backlog,
1978: 0 Oper_Acct_Net
1979: FROM fa_additions ad,
1980: fa_Books bk,
1981: fa_distribution_history dh,
1982: fa_deprn_Detail dd,
1983: gl_code_combinations cc,
1984: fa_categories cf,

Line 1999: FROM fa_books ifb

1995: AND fdp.book_type_code = bk.book_type_code
1996: AND fdp.period_counter = :v_period
1997: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
1998: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
1999: FROM fa_books ifb
2000: WHERE ifb.book_type_code = bk.book_type_code
2001: AND ifb.asset_id = bk.asset_id
2002: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
2003: AND dd.asset_id = bk.asset_id

Line 2075: fa_Books bk ,

2071: sum(nvl(id.operating_acct_cost * -1 ,0)) Oper_Acct_Cost,
2072: sum(nvl(id.operating_acct_backlog * -1,0)) Oper_Acct_Backlog,
2073: sum(nvl(id.operating_acct_net * -1 ,0)) Oper_Acct_Net
2074: FROM fa_additions ad ,
2075: fa_Books bk ,
2076: fa_distribution_history dh,
2077: fa_deprn_Detail dd ,
2078: igi_iac_det_balances id ,
2079: gl_code_combinations cc,

Line 2096: FROM fa_books ifb

2092: AND fdp.book_type_code = bk.book_type_code
2093: AND fdp.period_counter = :v_period1
2094: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
2095: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
2096: FROM fa_books ifb
2097: WHERE ifb.book_type_code = bk.book_type_code
2098: AND ifb.asset_id = bk.asset_id
2099: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
2100: AND dh.book_type_Code = bk.book_type_code

Line 2430: l_life_in_months fa_Books.life_in_months%TYPE;

2426: l_deprn_total NUMBER;
2427: l_asset_cat_id NUMBER(15);
2428: l_asset_tag fa_additions.tag_number%TYPE;
2429: l_serial_number fa_additions.serial_number%TYPE;
2430: l_life_in_months fa_Books.life_in_months%TYPE;
2431: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2432: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2434: l_location_id fa_distribution_history.location_id%TYPE;

Line 2431: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

2427: l_asset_cat_id NUMBER(15);
2428: l_asset_tag fa_additions.tag_number%TYPE;
2429: l_serial_number fa_additions.serial_number%TYPE;
2430: l_life_in_months fa_Books.life_in_months%TYPE;
2431: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2432: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2434: l_location_id fa_distribution_history.location_id%TYPE;
2435: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;

2429: l_serial_number fa_additions.serial_number%TYPE;
2430: l_life_in_months fa_Books.life_in_months%TYPE;
2431: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2432: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2433: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2434: l_location_id fa_distribution_history.location_id%TYPE;
2435: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2436: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2437: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 2476: fa_Books bk,

2472: 0 Reval_Reserve_Backlog,
2473: 0 Reval_Reserve_Gen_Fund,
2474: 0 Reval_Reserve_Net
2475: FROM fa_additions ad,
2476: fa_Books bk,
2477: fa_distribution_history dh,
2478: fa_deprn_Detail dd,
2479: gl_code_combinations cc,
2480: fa_categories cf,

Line 2495: FROM fa_books ifb

2491: AND fdp.book_type_code = bk.book_type_code
2492: AND fdp.period_counter = :v_period
2493: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
2494: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
2495: FROM fa_books ifb
2496: WHERE ifb.book_type_code = bk.book_type_code
2497: AND ifb.asset_id = bk.asset_id
2498: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
2499: AND dd.asset_id = bk.asset_id

Line 2554: fa_Books bk ,

2550: sum(nvl(id.reval_reserve_backlog, 0) ) Reval_Reserve_Backlog,
2551: sum(nvl(id.reval_reserve_gen_fund, 0)) Reval_Reserve_Gen_Fund,
2552: sum(nvl(id.reval_reserve_net, 0) ) Reval_Reserve_Net
2553: FROM fa_additions ad ,
2554: fa_Books bk ,
2555: fa_distribution_history dh ,
2556: fa_deprn_Detail dd ,
2557: igi_iac_det_balances id ,
2558: gl_code_combinations cc,

Line 2574: FROM fa_books ifb

2570: AND fdp.book_type_code = bk.book_type_code
2571: AND fdp.period_counter = :v_period1
2572: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
2573: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
2574: FROM fa_books ifb
2575: WHERE ifb.book_type_code = bk.book_type_code
2576: AND ifb.asset_id = bk.asset_id
2577: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
2578: AND bk.asset_id = ad.asset_id

Line 2821: l_life_in_months fa_Books.life_in_months%TYPE;

2817: l_asset_tag fa_additions.tag_number%TYPE;
2818: l_parent_id fa_additions.parent_asset_id%TYPE;
2819: l_parent_no VARCHAR2(15);
2820: l_serial_number fa_additions.serial_number%TYPE;
2821: l_life_in_months fa_Books.life_in_months%TYPE;
2822: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2823: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2825: l_location_id fa_distribution_history.location_id%TYPE;

Line 2822: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

2818: l_parent_id fa_additions.parent_asset_id%TYPE;
2819: l_parent_no VARCHAR2(15);
2820: l_serial_number fa_additions.serial_number%TYPE;
2821: l_life_in_months fa_Books.life_in_months%TYPE;
2822: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2823: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2825: l_location_id fa_distribution_history.location_id%TYPE;
2826: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;

2820: l_serial_number fa_additions.serial_number%TYPE;
2821: l_life_in_months fa_Books.life_in_months%TYPE;
2822: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
2823: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
2824: l_depreciation_method fa_Books.deprn_method_code%TYPE;
2825: l_location_id fa_distribution_history.location_id%TYPE;
2826: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
2827: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
2828: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 2879: fa_Books bk,

2875: 0 Reval_Reserve_Backlog,
2876: 0 Reval_Reserve_Gen_Fund,
2877: 0 Reval_Reserve_Net
2878: FROM fa_additions ad,
2879: fa_Books bk,
2880: fa_distribution_history dh,
2881: fa_deprn_Detail dd,
2882: gl_code_combinations cc,
2883: fa_categories cf,

Line 2898: FROM fa_books ifb

2894: AND fdp.book_type_code = bk.book_type_code
2895: AND fdp.period_counter = :v_period
2896: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
2897: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
2898: FROM fa_books ifb
2899: WHERE ifb.book_type_code = bk.book_type_code
2900: AND ifb.asset_id = bk.asset_id
2901: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
2902: AND dd.asset_id = bk.asset_id

Line 2975: fa_Books bk ,

2971: sum(nvl(id.reval_reserve_backlog, 0) ) Reval_Reserve_Backlog,
2972: sum(nvl(id.reval_reserve_gen_fund, 0)) Reval_Reserve_Gen_Fund,
2973: sum(nvl(id.reval_reserve_net, 0) ) Reval_Reserve_Net
2974: FROM fa_additions ad ,
2975: fa_Books bk ,
2976: fa_distribution_history dh ,
2977: fa_deprn_Detail dd ,
2978: igi_iac_det_balances id ,
2979: gl_code_combinations cc,

Line 2995: FROM fa_books ifb

2991: AND fdp.book_type_code = bk.book_type_code
2992: AND fdp.period_counter = :v_period1
2993: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
2994: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
2995: FROM fa_books ifb
2996: WHERE ifb.book_type_code = bk.book_type_code
2997: AND ifb.asset_id = bk.asset_id
2998: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
2999: AND bk.asset_id = ad.asset_id

Line 3326: l_life_in_months fa_Books.life_in_months%TYPE;

3322: l_deprn_total NUMBER;
3323: l_asset_cat_id NUMBER(15);
3324: l_asset_tag fa_additions.tag_number%TYPE;
3325: l_serial_number fa_additions.serial_number%TYPE;
3326: l_life_in_months fa_Books.life_in_months%TYPE;
3327: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3328: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3330: l_location_id fa_distribution_history.location_id%TYPE;

Line 3327: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

3323: l_asset_cat_id NUMBER(15);
3324: l_asset_tag fa_additions.tag_number%TYPE;
3325: l_serial_number fa_additions.serial_number%TYPE;
3326: l_life_in_months fa_Books.life_in_months%TYPE;
3327: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3328: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3330: l_location_id fa_distribution_history.location_id%TYPE;
3331: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;

3325: l_serial_number fa_additions.serial_number%TYPE;
3326: l_life_in_months fa_Books.life_in_months%TYPE;
3327: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3328: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3329: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3330: l_location_id fa_distribution_history.location_id%TYPE;
3331: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3332: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3333: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 3373: fa_Books bk,

3369: 0 Operating_Acct,
3370: sum(nvl(dd.deprn_reserve,0)) Acct_Deprn,
3371: 0 Backlog
3372: FROM fa_additions ad,
3373: fa_Books bk,
3374: fa_distribution_history dh,
3375: fa_deprn_Detail dd,
3376: gl_code_combinations cc,
3377: fa_categories cf,

Line 3392: FROM fa_books ifb

3388: AND fdp.book_type_code = bk.book_type_code
3389: AND fdp.period_counter = :v_period
3390: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
3391: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
3392: FROM fa_books ifb
3393: WHERE ifb.book_type_code = bk.book_type_code
3394: AND ifb.asset_id = bk.asset_id
3395: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
3396: AND dd.asset_id = bk.asset_id

Line 3452: fa_Books bk ,

3448: sum(nvl(id.operating_acct_net * -1, 0)) Operating_Acct,
3449: sum(nvl(id.deprn_reserve + dd.deprn_reserve, 0) ) Acct_Deprn,
3450: sum(nvl( id.deprn_reserve_backlog , 0)) Backlog
3451: FROM fa_additions ad ,
3452: fa_Books bk ,
3453: fa_distribution_history dh,
3454: fa_deprn_Detail dd ,
3455: igi_iac_det_balances id ,
3456: gl_code_combinations cc,

Line 3472: FROM fa_books ifb

3468: AND fdp.book_type_code = bk.book_type_code
3469: AND fdp.period_counter = :v_period1
3470: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
3471: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
3472: FROM fa_books ifb
3473: WHERE ifb.book_type_code = bk.book_type_code
3474: AND ifb.asset_id = bk.asset_id
3475: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
3476: AND bk.asset_id = ad.asset_id

Line 3716: l_life_in_months fa_Books.life_in_months%TYPE;

3712: l_asset_tag fa_additions.tag_number%TYPE;
3713: l_parent_id fa_additions.parent_asset_id%TYPE;
3714: l_parent_no VARCHAR2(15);
3715: l_serial_number fa_additions.serial_number%TYPE;
3716: l_life_in_months fa_Books.life_in_months%TYPE;
3717: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3718: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3720: l_location_id fa_distribution_history.location_id%TYPE;

Line 3717: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;

3713: l_parent_id fa_additions.parent_asset_id%TYPE;
3714: l_parent_no VARCHAR2(15);
3715: l_serial_number fa_additions.serial_number%TYPE;
3716: l_life_in_months fa_Books.life_in_months%TYPE;
3717: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3718: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3720: l_location_id fa_distribution_history.location_id%TYPE;
3721: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;

Line 3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;

3715: l_serial_number fa_additions.serial_number%TYPE;
3716: l_life_in_months fa_Books.life_in_months%TYPE;
3717: l_date_placed_in_service fa_Books.date_placed_in_service%TYPE;
3718: l_depreciation_reserve_account fa_category_books.deprn_reserve_acct%TYPE;
3719: l_depreciation_method fa_Books.deprn_method_code%TYPE;
3720: l_location_id fa_distribution_history.location_id%TYPE;
3721: l_asset_key_ccid fa_asset_keywords.code_combination_id%TYPE;
3722: l_asset_cost_account fa_category_books.asset_cost_acct%TYPE;
3723: l_deprn_res_acct fa_category_books.deprn_reserve_acct%TYPE;

Line 3775: fa_Books bk,

3771: 0 Operating_Acct,
3772: sum(nvl(dd.deprn_reserve,0)) Acct_Deprn,
3773: 0 Backlog
3774: FROM fa_additions ad,
3775: fa_Books bk,
3776: fa_distribution_history dh,
3777: fa_deprn_Detail dd,
3778: gl_code_combinations cc,
3779: fa_categories cf,

Line 3794: FROM fa_books ifb

3790: AND fdp.book_type_code = bk.book_type_code
3791: AND fdp.period_counter = :v_period
3792: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
3793: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
3794: FROM fa_books ifb
3795: WHERE ifb.book_type_code = bk.book_type_code
3796: AND ifb.asset_id = bk.asset_id
3797: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
3798: AND dd.asset_id = bk.asset_id

Line 3871: fa_Books bk ,

3867: sum(nvl(id.operating_acct_net * -1, 0)) Operating_Acct,
3868: sum(nvl(id.deprn_reserve + dd.deprn_reserve, 0) ) Acct_Deprn,
3869: sum(nvl( id.deprn_reserve_backlog , 0)) Backlog
3870: FROM fa_additions ad ,
3871: fa_Books bk ,
3872: fa_distribution_history dh,
3873: fa_deprn_Detail dd ,
3874: igi_iac_det_balances id ,
3875: gl_code_combinations cc,

Line 3891: FROM fa_books ifb

3887: AND fdp.book_type_code = bk.book_type_code
3888: AND fdp.period_counter = :v_period1
3889: AND nvl(bk.period_counter_fully_retired,fdp.period_counter+1) > fdp.period_counter
3890: AND bk.transaction_header_id_in = (SELECT max(ifb.transaction_header_id_in)
3891: FROM fa_books ifb
3892: WHERE ifb.book_type_code = bk.book_type_code
3893: AND ifb.asset_id = bk.asset_id
3894: AND ifb.date_effective < nvl(fdp.period_close_date,sysdate))
3895: AND bk.asset_id = ad.asset_id