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_ADDITIONS

Line 634: l_asset_tag fa_additions.tag_number%TYPE;

630: l_deprn_resv NUMBER;
631: l_deprn_backlog NUMBER;
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;

Line 635: l_serial_number fa_additions.serial_number%TYPE;

631: l_deprn_backlog NUMBER;
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;

Line 681: FROM fa_additions ad,

677: sum(nvl(dd.ytd_deprn,0)) YTD_Deprn,
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,

Line 759: FROM fa_additions ad ,

755: sum(decode(fd.fiscal_year,'||l_fiscal_year||',nvl(id.Deprn_YTD+ifd.deprn_ytd, 0),0)) YTD_Deprn,
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,

Line 1025: l_asset_tag fa_additions.tag_number%TYPE;

1021: l_deprn_resv NUMBER;
1022: l_deprn_backlog NUMBER;
1023: l_deprn_total NUMBER;
1024: l_asset_cat_id NUMBER(15);
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;

Line 1026: l_parent_id fa_additions.parent_asset_id%TYPE;

1022: l_deprn_backlog NUMBER;
1023: l_deprn_total NUMBER;
1024: l_asset_cat_id NUMBER(15);
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;

Line 1028: l_serial_number fa_additions.serial_number%TYPE;

1024: l_asset_cat_id NUMBER(15);
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;

Line 1049: l_ADDescription fa_additions.description%type;

1045: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1046: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1047: l_stl_rate NUMBER;
1048: l_CFDescription VARCHAR2(40);
1049: l_ADDescription fa_additions.description%type;
1050: l_from_asset VARCHAR2(100);
1051: l_to_asset VARCHAR2(100);
1052: l_from_cc VARCHAR2(100);
1053: l_to_cc VARCHAR2(100);

Line 1086: FROM fa_additions ad,

1082: sum(nvl(dd.ytd_deprn,0)) YTD_Deprn,
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,

Line 1183: FROM fa_additions ad ,

1179: sum(nvl(decode(fd.fiscal_year,'||l_fiscal_year||',id.Deprn_YTD+ifd.deprn_ytd, 0),0)) YTD_Deprn,
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,

Line 1544: l_asset_tag fa_additions.tag_number%TYPE;

1540: l_oper_exp NUMBER;
1541: l_oper_exp_backlog NUMBER;
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;

Line 1545: l_serial_number fa_additions.serial_number%TYPE;

1541: l_oper_exp_backlog NUMBER;
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;

Line 1591: FROM fa_additions ad,

1587: sum(nvl(dd.cost,0)) Reval_Cost,
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,

Line 1667: FROM fa_additions ad ,

1663: sum (nvl((id.adjustment_cost + dd.cost), 0)) Reval_Cost,
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 ,

Line 1918: l_asset_tag fa_additions.tag_number%TYPE;

1914: l_oper_exp NUMBER;
1915: l_oper_exp_backlog NUMBER;
1916: l_oper_exp_net NUMBER;
1917: l_asset_cat_id NUMBER(15);
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;

Line 1919: l_parent_id fa_additions.parent_asset_id%TYPE;

1915: l_oper_exp_backlog NUMBER;
1916: l_oper_exp_net NUMBER;
1917: l_asset_cat_id NUMBER(15);
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;

Line 1921: l_serial_number fa_additions.serial_number%TYPE;

1917: l_asset_cat_id NUMBER(15);
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;

Line 1942: l_ADDescription fa_additions.description%type;

1938: l_asset_segs fa_rx_shared_pkg.Seg_Array;
1939: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1940: l_stl_rate NUMBER;
1941: l_CFDescription VARCHAR2(40);
1942: l_ADDescription fa_additions.description%type;
1943: l_from_asset VARCHAR2(100);
1944: l_to_asset VARCHAR2(100);
1945: l_from_cc VARCHAR2(100);
1946: l_to_cc VARCHAR2(100);

Line 1979: FROM fa_additions ad,

1975: sum(nvl(dd.cost,0)) Reval_Cost,
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,

Line 2074: FROM fa_additions ad ,

2070: sum (nvl( id.adjustment_cost,0) + dd.cost) Reval_Cost,
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 ,

Line 2428: l_asset_tag fa_additions.tag_number%TYPE;

2424: l_ytd_deprn NUMBER;
2425: l_deprn_backlog NUMBER;
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;

Line 2429: l_serial_number fa_additions.serial_number%TYPE;

2425: l_deprn_backlog NUMBER;
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;

Line 2475: FROM fa_additions ad,

2471: 0 Reval_Reserve_Cost,
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,

Line 2553: FROM fa_additions ad ,

2549: sum(nvl(id.reval_reserve_cost, 0) ) Reval_Reserve_Cost,
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 ,

Line 2817: l_asset_tag fa_additions.tag_number%TYPE;

2813: l_ytd_deprn NUMBER;
2814: l_deprn_backlog NUMBER;
2815: l_deprn_total NUMBER;
2816: l_asset_cat_id NUMBER(15);
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;

Line 2818: l_parent_id fa_additions.parent_asset_id%TYPE;

2814: l_deprn_backlog NUMBER;
2815: l_deprn_total NUMBER;
2816: l_asset_cat_id NUMBER(15);
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;

Line 2820: l_serial_number fa_additions.serial_number%TYPE;

2816: l_asset_cat_id NUMBER(15);
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;

Line 2841: l_ADDescription fa_additions.description%type;

2837: l_asset_segs fa_rx_shared_pkg.Seg_Array;
2838: l_cat_segs fa_rx_shared_pkg.Seg_Array;
2839: l_stl_rate NUMBER;
2840: l_CFDescription VARCHAR2(40);
2841: l_ADDescription fa_additions.description%type;
2842: l_from_asset VARCHAR2(100);
2843: l_to_asset VARCHAR2(100);
2844: l_from_cc VARCHAR2(100);
2845: l_to_cc VARCHAR2(100);

Line 2878: FROM fa_additions ad,

2874: 0 Reval_Reserve_Cost,
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,

Line 2974: FROM fa_additions ad ,

2970: sum(nvl(id.reval_reserve_cost, 0) ) Reval_Reserve_Cost,
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 ,

Line 3324: l_asset_tag fa_additions.tag_number%TYPE;

3320: l_ytd_deprn NUMBER;
3321: l_deprn_backlog NUMBER;
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;

Line 3325: l_serial_number fa_additions.serial_number%TYPE;

3321: l_deprn_backlog NUMBER;
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;

Line 3372: FROM fa_additions ad,

3368: 0 Gen_Fund,
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,

Line 3451: FROM fa_additions ad ,

3447: sum(nvl(id.reval_reserve_gen_fund, 0)) Gen_Fund,
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 ,

Line 3712: l_asset_tag fa_additions.tag_number%TYPE;

3708: l_ytd_deprn NUMBER;
3709: l_deprn_backlog NUMBER;
3710: l_deprn_total NUMBER;
3711: l_asset_cat_id NUMBER(15);
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;

Line 3713: l_parent_id fa_additions.parent_asset_id%TYPE;

3709: l_deprn_backlog NUMBER;
3710: l_deprn_total NUMBER;
3711: l_asset_cat_id NUMBER(15);
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;

Line 3715: l_serial_number fa_additions.serial_number%TYPE;

3711: l_asset_cat_id NUMBER(15);
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;

Line 3736: l_ADDescription fa_additions.description%type;

3732: l_asset_segs fa_rx_shared_pkg.Seg_Array;
3733: l_cat_segs fa_rx_shared_pkg.Seg_Array;
3734: l_stl_rate NUMBER;
3735: l_CFDescription VARCHAR2(40);
3736: l_ADDescription fa_additions.description%type;
3737: l_from_asset VARCHAR2(100);
3738: l_to_asset VARCHAR2(100);
3739: l_from_cc VARCHAR2(100);
3740: l_to_cc VARCHAR2(100);

Line 3774: FROM fa_additions ad,

3770: 0 Gen_Fund,
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,

Line 3870: FROM fa_additions ad ,

3866: sum(nvl(id.reval_reserve_gen_fund, 0)) Gen_Fund,
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 ,