[Home] [Help]
445:
446:
447: if (h_reporting_flag = 'R') then
448:
449: INSERT INTO FA_BALANCES_REPORT_GT
450: (Asset_ID,
451: Distribution_CCID,
452: Adjustment_CCID,
453: Category_Books_Account,
520: AJ.Source_Type_Code;
521:
522: else
523:
524: INSERT INTO FA_BALANCES_REPORT_GT
525: (Asset_ID,
526: Distribution_CCID,
527: Adjustment_CCID,
528: Category_Books_Account,
600: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
601:
602: if (h_reporting_flag = 'R') then
603:
604: INSERT INTO FA_BALANCES_REPORT_GT
605: (Asset_ID,
606: Distribution_CCID,
607: Adjustment_CCID,
608: Category_Books_Account,
681: AJ.Source_Type_Code;
682:
683: else
684:
685: INSERT INTO FA_BALANCES_REPORT_GT
686: (Asset_ID,
687: Distribution_CCID,
688: Adjustment_CCID,
689: Category_Books_Account,
767: end if;
768:
769: IF REPORT_TYPE = 'RESERVE' then
770: if (h_reporting_flag = 'R') then
771: insert into FA_BALANCES_REPORT_GT
772: (Asset_id,
773: Distribution_CCID,
774: Adjustment_CCID,
775: Category_books_account,
786: FA_CATEGORY_BOOKS CB,
787: FA_ASSET_HISTORY AH,
788: FA_DEPRN_DETAIL_MRC_V DD
789: WHERE NOT EXISTS (SELECT ASSET_ID
790: FROM FA_BALANCES_REPORT_GT
791: WHERE ASSET_ID = DH.ASSET_ID
792: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
793: AND SOURCE_TYPE_CODE = 'ADDITION')
794: AND DD.BOOK_TYPE_CODE = BOOK
809: Dh.ASSET_ID,
810: DH.CODE_COMBINATION_ID,
811: CB.DEPRN_RESERVE_ACCT;
812: else
813: insert into FA_BALANCES_REPORT_GT
814: (Asset_id,
815: Distribution_CCID,
816: Adjustment_CCID,
817: Category_books_account,
828: FA_CATEGORY_BOOKS CB,
829: FA_ASSET_HISTORY AH,
830: FA_DEPRN_DETAIL DD
831: WHERE NOT EXISTS (SELECT ASSET_ID
832: FROM FA_BALANCES_REPORT_GT
833: WHERE ASSET_ID = DH.ASSET_ID
834: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
835: AND SOURCE_TYPE_CODE = 'ADDITION')
836: AND DD.BOOK_TYPE_CODE = BOOK
910: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
911:
912: if (h_reporting_flag = 'R') then
913:
914: INSERT INTO FA_BALANCES_REPORT_GT
915: (Asset_ID,
916: Distribution_CCID,
917: Adjustment_CCID,
918: Category_Books_Account,
981: decode(aj.adjustment_type,'COST',GAD.ASSET_COST_ACCT_CCID,lines.code_combination_id /*AJ.Code_Combination_ID*/ ),
982: aJ.Source_Type_Code;
983: else
984:
985: INSERT INTO FA_BALANCES_REPORT_GT
986: (Asset_ID,
987: Distribution_CCID,
988: Adjustment_CCID,
989: Category_Books_Account,
1110: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
1111:
1112: if (h_reporting_flag = 'R') then
1113:
1114: INSERT INTO FA_BALANCES_REPORT_GT
1115: (Asset_ID,
1116: Distribution_CCID,
1117: Adjustment_CCID,
1118: Category_Books_Account,
1207: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1208: else
1209: -- split for 'COST','CIP COST' and 'RESERVE','REVAL RESERVE' for better performance.
1210: if report_type in ('COST', 'CIP COST') then
1211: INSERT INTO FA_BALANCES_REPORT_GT
1212: (Asset_ID,
1213: Distribution_CCID,
1214: Adjustment_CCID,
1215: Category_Books_Account,
1301: 'RESERVE', CB.Deprn_Reserve_Acct,
1302: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1303: else -- report_type in ('RESERVE','REVAL RESERVE')
1304:
1305: INSERT INTO FA_BALANCES_REPORT_GT
1306: (Asset_ID,
1307: Distribution_CCID,
1308: Adjustment_CCID,
1309: Category_Books_Account,
1395: -- Fix for Bug #1892406. Run only if CRL installed.
1396: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
1397:
1398: if (h_reporting_flag = 'R') then
1399: INSERT INTO FA_BALANCES_REPORT_GT
1400: (Asset_ID,
1401: Distribution_CCID,
1402: Adjustment_CCID,
1403: Category_Books_Account,
1492: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null
1493: -- start of CUA - This is to exclude the Group Asset Members
1494: and bk.GROUP_ASSET_ID IS NULL;
1495: else
1496: INSERT INTO FA_BALANCES_REPORT_GT
1497: (Asset_ID,
1498: Distribution_CCID,
1499: Adjustment_CCID,
1500: Category_Books_Account,
1646: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1647:
1648: if ( report_type not in ('RESERVE') ) THEN
1649: if (h_reporting_flag = 'R') then
1650: INSERT INTO FA_BALANCES_REPORT_GT
1651: (Asset_ID,
1652: Distribution_CCID,
1653: Adjustment_CCID,
1654: Category_Books_Account,
1749: null),
1750: 'RESERVE', CB.Deprn_Reserve_Acct,
1751: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1752: else
1753: INSERT INTO FA_BALANCES_REPORT_GT
1754: (Asset_ID,
1755: Distribution_CCID,
1756: Adjustment_CCID,
1757: Category_Books_Account,
1857:
1858: -- Get the Depreciation reserve begin balance
1859:
1860: if (h_reporting_flag = 'R') then
1861: INSERT INTO FA_BALANCES_REPORT_GT
1862: (Asset_ID,
1863: Distribution_CCID,
1864: Adjustment_CCID,
1865: Category_Books_Account,
1896: WHERE DD_SUB.BOOK_TYPE_CODE = book
1897: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1898: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1899: else
1900: INSERT INTO FA_BALANCES_REPORT_GT
1901: (Asset_ID,
1902: Distribution_CCID,
1903: Adjustment_CCID,
1904: Category_Books_Account,
1994: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1995:
1996: IF REPORT_TYPE NOT IN ('RESERVE') THEN
1997: if (h_reporting_flag = 'R') then
1998: INSERT INTO FA_BALANCES_REPORT_GT
1999: (Asset_ID,
2000: Distribution_CCID,
2001: Adjustment_CCID,
2002: Category_Books_Account,
2094: null),
2095: 'RESERVE', CB.Deprn_Reserve_Acct,
2096: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
2097: else
2098: INSERT INTO FA_BALANCES_REPORT_GT
2099: (Asset_ID,
2100: Distribution_CCID,
2101: Adjustment_CCID,
2102: Category_Books_Account,
2198:
2199: ELSE
2200:
2201: if (h_reporting_flag = 'R') then
2202: INSERT INTO FA_BALANCES_REPORT_GT
2203: (Asset_ID,
2204: Distribution_CCID,
2205: Adjustment_CCID,
2206: Category_Books_Account,
2236: WHERE DD_SUB.BOOK_TYPE_CODE = book
2237: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2238: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2239: else
2240: INSERT INTO FA_BALANCES_REPORT_GT
2241: (Asset_ID,
2242: Distribution_CCID,
2243: Adjustment_CCID,
2244: Category_Books_Account,
2321: h_reporting_flag := 'P';
2322: end if;
2323:
2324: if (h_reporting_flag = 'R') then
2325: INSERT INTO FA_BALANCES_REPORT_GT
2326: (Asset_ID,
2327: Distribution_CCID,
2328: Adjustment_CCID,
2329: Category_Books_Account,
2400: 'RESERVE', CB.Deprn_Reserve_Acct,
2401: 'REVAL RESERVE', CB.Reval_Reserve_Acct),
2402: DD.Deprn_Source_Code;
2403: else
2404: INSERT INTO FA_BALANCES_REPORT_GT
2405: (Asset_ID,
2406: Distribution_CCID,
2407: Adjustment_CCID,
2408: Category_Books_Account,
2486:
2487: -- Get the Group Depreciation Effects
2488:
2489: if (h_reporting_flag = 'R') then
2490: INSERT INTO FA_BALANCES_REPORT_GT
2491: (Asset_ID,
2492: Distribution_CCID,
2493: Adjustment_CCID,
2494: Category_Books_Account,
2519: GAD.DEPRN_RESERVE_ACCT_CCID ,
2520: null,
2521: 'DEPRECIATION' ;
2522: else
2523: INSERT INTO FA_BALANCES_REPORT_GT
2524: (Asset_ID,
2525: Distribution_CCID,
2526: Adjustment_CCID,
2527: Category_Books_Account,
2667: else
2668: Balance_Type := 'DR';
2669: end if;
2670:
2671: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2672:
2673: /*This section of code needs to be replaced due to the fact that in 11.5 the
2674: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2675: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two