[Home] [Help]
454:
455:
456: if (h_reporting_flag = 'R') then
457:
458: INSERT INTO FA_BALANCES_REPORT_GT
459: (Asset_ID,
460: Distribution_CCID,
461: Adjustment_CCID,
462: Category_Books_Account,
529: AJ.Source_Type_Code;
530:
531: else
532:
533: INSERT INTO FA_BALANCES_REPORT_GT
534: (Asset_ID,
535: Distribution_CCID,
536: Adjustment_CCID,
537: Category_Books_Account,
609: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
610:
611: if (h_reporting_flag = 'R') then
612:
613: INSERT INTO FA_BALANCES_REPORT_GT
614: (Asset_ID,
615: Distribution_CCID,
616: Adjustment_CCID,
617: Category_Books_Account,
690: AJ.Source_Type_Code;
691:
692: else
693:
694: INSERT INTO FA_BALANCES_REPORT_GT
695: (Asset_ID,
696: Distribution_CCID,
697: Adjustment_CCID,
698: Category_Books_Account,
776: end if;
777:
778: IF REPORT_TYPE = 'RESERVE' then
779: if (h_reporting_flag = 'R') then
780: insert into FA_BALANCES_REPORT_GT
781: (Asset_id,
782: Distribution_CCID,
783: Adjustment_CCID,
784: Category_books_account,
795: FA_CATEGORY_BOOKS CB,
796: FA_ASSET_HISTORY AH,
797: FA_DEPRN_DETAIL_MRC_V DD
798: WHERE NOT EXISTS (SELECT ASSET_ID
799: FROM FA_BALANCES_REPORT_GT
800: WHERE ASSET_ID = DH.ASSET_ID
801: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
802: AND SOURCE_TYPE_CODE = 'ADDITION')
803: AND DD.BOOK_TYPE_CODE = BOOK
818: Dh.ASSET_ID,
819: DH.CODE_COMBINATION_ID,
820: CB.DEPRN_RESERVE_ACCT;
821: else
822: insert into FA_BALANCES_REPORT_GT
823: (Asset_id,
824: Distribution_CCID,
825: Adjustment_CCID,
826: Category_books_account,
837: FA_CATEGORY_BOOKS CB,
838: FA_ASSET_HISTORY AH,
839: FA_DEPRN_DETAIL DD
840: WHERE NOT EXISTS (SELECT ASSET_ID
841: FROM FA_BALANCES_REPORT_GT
842: WHERE ASSET_ID = DH.ASSET_ID
843: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
844: AND SOURCE_TYPE_CODE = 'ADDITION')
845: AND DD.BOOK_TYPE_CODE = BOOK
913: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
914:
915: if (h_reporting_flag = 'R') then
916:
917: INSERT INTO FA_BALANCES_REPORT_GT
918: (Asset_ID,
919: Distribution_CCID,
920: Adjustment_CCID,
921: Category_Books_Account,
984: decode(aj.adjustment_type,'COST',GAD.ASSET_COST_ACCT_CCID,lines.code_combination_id /*AJ.Code_Combination_ID*/ ),
985: aJ.Source_Type_Code;
986: else
987:
988: INSERT INTO FA_BALANCES_REPORT_GT
989: (Asset_ID,
990: Distribution_CCID,
991: Adjustment_CCID,
992: Category_Books_Account,
1105: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
1106:
1107: if (h_reporting_flag = 'R') then
1108:
1109: INSERT INTO FA_BALANCES_REPORT_GT
1110: (Asset_ID,
1111: Distribution_CCID,
1112: Adjustment_CCID,
1113: Category_Books_Account,
1202: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1203: else
1204: -- split for 'COST','CIP COST' and 'RESERVE','REVAL RESERVE' for better performance.
1205: if report_type in ('COST', 'CIP COST') then
1206: INSERT INTO FA_BALANCES_REPORT_GT
1207: (Asset_ID,
1208: Distribution_CCID,
1209: Adjustment_CCID,
1210: Category_Books_Account,
1296: 'RESERVE', CB.Deprn_Reserve_Acct,
1297: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1298: else -- report_type in ('RESERVE','REVAL RESERVE')
1299:
1300: INSERT INTO FA_BALANCES_REPORT_GT
1301: (Asset_ID,
1302: Distribution_CCID,
1303: Adjustment_CCID,
1304: Category_Books_Account,
1390: -- Fix for Bug #1892406. Run only if CRL installed.
1391: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
1392:
1393: if (h_reporting_flag = 'R') then
1394: INSERT INTO FA_BALANCES_REPORT_GT
1395: (Asset_ID,
1396: Distribution_CCID,
1397: Adjustment_CCID,
1398: Category_Books_Account,
1487: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null
1488: -- start of CUA - This is to exclude the Group Asset Members
1489: and bk.GROUP_ASSET_ID IS NULL;
1490: else
1491: INSERT INTO FA_BALANCES_REPORT_GT
1492: (Asset_ID,
1493: Distribution_CCID,
1494: Adjustment_CCID,
1495: Category_Books_Account,
1635: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1636:
1637: if ( report_type not in ('RESERVE') ) THEN
1638: if (h_reporting_flag = 'R') then
1639: INSERT INTO FA_BALANCES_REPORT_GT
1640: (Asset_ID,
1641: Distribution_CCID,
1642: Adjustment_CCID,
1643: Category_Books_Account,
1738: null),
1739: 'RESERVE', CB.Deprn_Reserve_Acct,
1740: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1741: else
1742: INSERT INTO FA_BALANCES_REPORT_GT
1743: (Asset_ID,
1744: Distribution_CCID,
1745: Adjustment_CCID,
1746: Category_Books_Account,
1846:
1847: -- Get the Depreciation reserve begin balance
1848:
1849: if (h_reporting_flag = 'R') then
1850: INSERT INTO FA_BALANCES_REPORT_GT
1851: (Asset_ID,
1852: Distribution_CCID,
1853: Adjustment_CCID,
1854: Category_Books_Account,
1885: WHERE DD_SUB.BOOK_TYPE_CODE = book
1886: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1887: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1888: else
1889: INSERT INTO FA_BALANCES_REPORT_GT
1890: (Asset_ID,
1891: Distribution_CCID,
1892: Adjustment_CCID,
1893: Category_Books_Account,
1974: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1975:
1976: IF REPORT_TYPE NOT IN ('RESERVE') THEN
1977: if (h_reporting_flag = 'R') then
1978: INSERT INTO FA_BALANCES_REPORT_GT
1979: (Asset_ID,
1980: Distribution_CCID,
1981: Adjustment_CCID,
1982: Category_Books_Account,
2074: null),
2075: 'RESERVE', CB.Deprn_Reserve_Acct,
2076: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
2077: else
2078: INSERT INTO FA_BALANCES_REPORT_GT
2079: (Asset_ID,
2080: Distribution_CCID,
2081: Adjustment_CCID,
2082: Category_Books_Account,
2178:
2179: ELSE
2180:
2181: if (h_reporting_flag = 'R') then
2182: INSERT INTO FA_BALANCES_REPORT_GT
2183: (Asset_ID,
2184: Distribution_CCID,
2185: Adjustment_CCID,
2186: Category_Books_Account,
2216: WHERE DD_SUB.BOOK_TYPE_CODE = book
2217: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2218: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2219: else
2220: INSERT INTO FA_BALANCES_REPORT_GT
2221: (Asset_ID,
2222: Distribution_CCID,
2223: Adjustment_CCID,
2224: Category_Books_Account,
2293: h_reporting_flag := 'P';
2294: end if;
2295:
2296: if (h_reporting_flag = 'R') then
2297: INSERT INTO FA_BALANCES_REPORT_GT
2298: (Asset_ID,
2299: Distribution_CCID,
2300: Adjustment_CCID,
2301: Category_Books_Account,
2372: 'RESERVE', CB.Deprn_Reserve_Acct,
2373: 'REVAL RESERVE', CB.Reval_Reserve_Acct),
2374: DD.Deprn_Source_Code;
2375: else
2376: INSERT INTO FA_BALANCES_REPORT_GT
2377: (Asset_ID,
2378: Distribution_CCID,
2379: Adjustment_CCID,
2380: Category_Books_Account,
2458:
2459: -- Get the Group Depreciation Effects
2460:
2461: if (h_reporting_flag = 'R') then
2462: INSERT INTO FA_BALANCES_REPORT_GT
2463: (Asset_ID,
2464: Distribution_CCID,
2465: Adjustment_CCID,
2466: Category_Books_Account,
2491: GAD.DEPRN_RESERVE_ACCT_CCID ,
2492: null,
2493: 'DEPRECIATION' ;
2494: else
2495: INSERT INTO FA_BALANCES_REPORT_GT
2496: (Asset_ID,
2497: Distribution_CCID,
2498: Adjustment_CCID,
2499: Category_Books_Account,
2636: else
2637: Balance_Type := 'DR';
2638: end if;
2639:
2640: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2641:
2642: /*This section of code needs to be replaced due to the fact that in 11.5 the
2643: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2644: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two