[Home] [Help]
427:
428:
429: if (h_reporting_flag = 'R') then
430:
431: INSERT INTO FA_BALANCES_REPORT_GT
432: (Asset_ID,
433: Distribution_CCID,
434: Adjustment_CCID,
435: Category_Books_Account,
502: AJ.Source_Type_Code;
503:
504: else
505:
506: INSERT INTO FA_BALANCES_REPORT_GT
507: (Asset_ID,
508: Distribution_CCID,
509: Adjustment_CCID,
510: Category_Books_Account,
582: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
583:
584: if (h_reporting_flag = 'R') then
585:
586: INSERT INTO FA_BALANCES_REPORT_GT
587: (Asset_ID,
588: Distribution_CCID,
589: Adjustment_CCID,
590: Category_Books_Account,
663: AJ.Source_Type_Code;
664:
665: else
666:
667: INSERT INTO FA_BALANCES_REPORT_GT
668: (Asset_ID,
669: Distribution_CCID,
670: Adjustment_CCID,
671: Category_Books_Account,
749: end if;
750:
751: IF REPORT_TYPE = 'RESERVE' then
752: if (h_reporting_flag = 'R') then
753: insert into FA_BALANCES_REPORT_GT
754: (Asset_id,
755: Distribution_CCID,
756: Adjustment_CCID,
757: Category_books_account,
768: FA_CATEGORY_BOOKS CB,
769: FA_ASSET_HISTORY AH,
770: FA_DEPRN_DETAIL_MRC_V DD
771: WHERE NOT EXISTS (SELECT ASSET_ID
772: FROM FA_BALANCES_REPORT_GT
773: WHERE ASSET_ID = DH.ASSET_ID
774: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
775: AND SOURCE_TYPE_CODE = 'ADDITION')
776: AND DD.BOOK_TYPE_CODE = BOOK
791: Dh.ASSET_ID,
792: DH.CODE_COMBINATION_ID,
793: CB.DEPRN_RESERVE_ACCT;
794: else
795: insert into FA_BALANCES_REPORT_GT
796: (Asset_id,
797: Distribution_CCID,
798: Adjustment_CCID,
799: Category_books_account,
810: FA_CATEGORY_BOOKS CB,
811: FA_ASSET_HISTORY AH,
812: FA_DEPRN_DETAIL DD
813: WHERE NOT EXISTS (SELECT ASSET_ID
814: FROM FA_BALANCES_REPORT_GT
815: WHERE ASSET_ID = DH.ASSET_ID
816: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
817: AND SOURCE_TYPE_CODE = 'ADDITION')
818: AND DD.BOOK_TYPE_CODE = BOOK
886: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
887:
888: if (h_reporting_flag = 'R') then
889:
890: INSERT INTO FA_BALANCES_REPORT_GT
891: (Asset_ID,
892: Distribution_CCID,
893: Adjustment_CCID,
894: Category_Books_Account,
957: decode(aj.adjustment_type,'COST',GAD.ASSET_COST_ACCT_CCID,lines.code_combination_id /*AJ.Code_Combination_ID*/ ),
958: aJ.Source_Type_Code;
959: else
960:
961: INSERT INTO FA_BALANCES_REPORT_GT
962: (Asset_ID,
963: Distribution_CCID,
964: Adjustment_CCID,
965: Category_Books_Account,
1078: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
1079:
1080: if (h_reporting_flag = 'R') then
1081:
1082: INSERT INTO FA_BALANCES_REPORT_GT
1083: (Asset_ID,
1084: Distribution_CCID,
1085: Adjustment_CCID,
1086: Category_Books_Account,
1175: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1176: else
1177: -- split for 'COST','CIP COST' and 'RESERVE','REVAL RESERVE' for better performance.
1178: if report_type in ('COST', 'CIP COST') then
1179: INSERT INTO FA_BALANCES_REPORT_GT
1180: (Asset_ID,
1181: Distribution_CCID,
1182: Adjustment_CCID,
1183: Category_Books_Account,
1269: 'RESERVE', CB.Deprn_Reserve_Acct,
1270: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1271: else -- report_type in ('RESERVE','REVAL RESERVE')
1272:
1273: INSERT INTO FA_BALANCES_REPORT_GT
1274: (Asset_ID,
1275: Distribution_CCID,
1276: Adjustment_CCID,
1277: Category_Books_Account,
1363: -- Fix for Bug #1892406. Run only if CRL installed.
1364: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
1365:
1366: if (h_reporting_flag = 'R') then
1367: INSERT INTO FA_BALANCES_REPORT_GT
1368: (Asset_ID,
1369: Distribution_CCID,
1370: Adjustment_CCID,
1371: Category_Books_Account,
1460: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null
1461: -- start of CUA - This is to exclude the Group Asset Members
1462: and bk.GROUP_ASSET_ID IS NULL;
1463: else
1464: INSERT INTO FA_BALANCES_REPORT_GT
1465: (Asset_ID,
1466: Distribution_CCID,
1467: Adjustment_CCID,
1468: Category_Books_Account,
1608: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1609:
1610: if ( report_type not in ('RESERVE') ) THEN
1611: if (h_reporting_flag = 'R') then
1612: INSERT INTO FA_BALANCES_REPORT_GT
1613: (Asset_ID,
1614: Distribution_CCID,
1615: Adjustment_CCID,
1616: Category_Books_Account,
1711: null),
1712: 'RESERVE', CB.Deprn_Reserve_Acct,
1713: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1714: else
1715: INSERT INTO FA_BALANCES_REPORT_GT
1716: (Asset_ID,
1717: Distribution_CCID,
1718: Adjustment_CCID,
1719: Category_Books_Account,
1819:
1820: -- Get the Depreciation reserve begin balance
1821:
1822: if (h_reporting_flag = 'R') then
1823: INSERT INTO FA_BALANCES_REPORT_GT
1824: (Asset_ID,
1825: Distribution_CCID,
1826: Adjustment_CCID,
1827: Category_Books_Account,
1858: WHERE DD_SUB.BOOK_TYPE_CODE = book
1859: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1860: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1861: else
1862: INSERT INTO FA_BALANCES_REPORT_GT
1863: (Asset_ID,
1864: Distribution_CCID,
1865: Adjustment_CCID,
1866: Category_Books_Account,
1947: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1948:
1949: IF REPORT_TYPE NOT IN ('RESERVE') THEN
1950: if (h_reporting_flag = 'R') then
1951: INSERT INTO FA_BALANCES_REPORT_GT
1952: (Asset_ID,
1953: Distribution_CCID,
1954: Adjustment_CCID,
1955: Category_Books_Account,
2047: null),
2048: 'RESERVE', CB.Deprn_Reserve_Acct,
2049: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
2050: else
2051: INSERT INTO FA_BALANCES_REPORT_GT
2052: (Asset_ID,
2053: Distribution_CCID,
2054: Adjustment_CCID,
2055: Category_Books_Account,
2151:
2152: ELSE
2153:
2154: if (h_reporting_flag = 'R') then
2155: INSERT INTO FA_BALANCES_REPORT_GT
2156: (Asset_ID,
2157: Distribution_CCID,
2158: Adjustment_CCID,
2159: Category_Books_Account,
2189: WHERE DD_SUB.BOOK_TYPE_CODE = book
2190: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2191: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2192: else
2193: INSERT INTO FA_BALANCES_REPORT_GT
2194: (Asset_ID,
2195: Distribution_CCID,
2196: Adjustment_CCID,
2197: Category_Books_Account,
2266: h_reporting_flag := 'P';
2267: end if;
2268:
2269: if (h_reporting_flag = 'R') then
2270: INSERT INTO FA_BALANCES_REPORT_GT
2271: (Asset_ID,
2272: Distribution_CCID,
2273: Adjustment_CCID,
2274: Category_Books_Account,
2345: 'RESERVE', CB.Deprn_Reserve_Acct,
2346: 'REVAL RESERVE', CB.Reval_Reserve_Acct),
2347: DD.Deprn_Source_Code;
2348: else
2349: INSERT INTO FA_BALANCES_REPORT_GT
2350: (Asset_ID,
2351: Distribution_CCID,
2352: Adjustment_CCID,
2353: Category_Books_Account,
2431:
2432: -- Get the Group Depreciation Effects
2433:
2434: if (h_reporting_flag = 'R') then
2435: INSERT INTO FA_BALANCES_REPORT_GT
2436: (Asset_ID,
2437: Distribution_CCID,
2438: Adjustment_CCID,
2439: Category_Books_Account,
2464: GAD.DEPRN_RESERVE_ACCT_CCID ,
2465: null,
2466: 'DEPRECIATION' ;
2467: else
2468: INSERT INTO FA_BALANCES_REPORT_GT
2469: (Asset_ID,
2470: Distribution_CCID,
2471: Adjustment_CCID,
2472: Category_Books_Account,
2609: else
2610: Balance_Type := 'DR';
2611: end if;
2612:
2613: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2614:
2615: /*This section of code needs to be replaced due to the fact that in 11.5 the
2616: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2617: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two