[Home] [Help]
421:
422:
423: if (h_reporting_flag = 'R') then
424:
425: INSERT INTO FA_BALANCES_REPORT_GT
426: (Asset_ID,
427: Distribution_CCID,
428: Adjustment_CCID,
429: Category_Books_Account,
496: AJ.Source_Type_Code;
497:
498: else
499:
500: INSERT INTO FA_BALANCES_REPORT_GT
501: (Asset_ID,
502: Distribution_CCID,
503: Adjustment_CCID,
504: Category_Books_Account,
576: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
577:
578: if (h_reporting_flag = 'R') then
579:
580: INSERT INTO FA_BALANCES_REPORT_GT
581: (Asset_ID,
582: Distribution_CCID,
583: Adjustment_CCID,
584: Category_Books_Account,
657: AJ.Source_Type_Code;
658:
659: else
660:
661: INSERT INTO FA_BALANCES_REPORT_GT
662: (Asset_ID,
663: Distribution_CCID,
664: Adjustment_CCID,
665: Category_Books_Account,
743: end if;
744:
745: IF REPORT_TYPE = 'RESERVE' then
746: if (h_reporting_flag = 'R') then
747: insert into FA_BALANCES_REPORT_GT
748: (Asset_id,
749: Distribution_CCID,
750: Adjustment_CCID,
751: Category_books_account,
762: FA_CATEGORY_BOOKS CB,
763: FA_ASSET_HISTORY AH,
764: FA_DEPRN_DETAIL_MRC_V DD
765: WHERE NOT EXISTS (SELECT ASSET_ID
766: FROM FA_BALANCES_REPORT_GT
767: WHERE ASSET_ID = DH.ASSET_ID
768: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
769: AND SOURCE_TYPE_CODE = 'ADDITION')
770: AND DD.BOOK_TYPE_CODE = BOOK
785: Dh.ASSET_ID,
786: DH.CODE_COMBINATION_ID,
787: CB.DEPRN_RESERVE_ACCT;
788: else
789: insert into FA_BALANCES_REPORT_GT
790: (Asset_id,
791: Distribution_CCID,
792: Adjustment_CCID,
793: Category_books_account,
804: FA_CATEGORY_BOOKS CB,
805: FA_ASSET_HISTORY AH,
806: FA_DEPRN_DETAIL DD
807: WHERE NOT EXISTS (SELECT ASSET_ID
808: FROM FA_BALANCES_REPORT_GT
809: WHERE ASSET_ID = DH.ASSET_ID
810: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
811: AND SOURCE_TYPE_CODE = 'ADDITION')
812: 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,
1086: If (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N' ) then
1087:
1088: if (h_reporting_flag = 'R') then
1089:
1090: INSERT INTO FA_BALANCES_REPORT_GT
1091: (Asset_ID,
1092: Distribution_CCID,
1093: Adjustment_CCID,
1094: Category_Books_Account,
1183: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1184: else
1185: -- split for 'COST','CIP COST' and 'RESERVE','REVAL RESERVE' for better performance.
1186: if report_type in ('COST', 'CIP COST') then
1187: INSERT INTO FA_BALANCES_REPORT_GT
1188: (Asset_ID,
1189: Distribution_CCID,
1190: Adjustment_CCID,
1191: Category_Books_Account,
1277: 'RESERVE', CB.Deprn_Reserve_Acct,
1278: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1279: else -- report_type in ('RESERVE','REVAL RESERVE')
1280:
1281: INSERT INTO FA_BALANCES_REPORT_GT
1282: (Asset_ID,
1283: Distribution_CCID,
1284: Adjustment_CCID,
1285: Category_Books_Account,
1371: -- Fix for Bug #1892406. Run only if CRL installed.
1372: elsif (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y' ) then
1373:
1374: if (h_reporting_flag = 'R') then
1375: INSERT INTO FA_BALANCES_REPORT_GT
1376: (Asset_ID,
1377: Distribution_CCID,
1378: Adjustment_CCID,
1379: Category_Books_Account,
1468: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null
1469: -- start of CUA - This is to exclude the Group Asset Members
1470: and bk.GROUP_ASSET_ID IS NULL;
1471: else
1472: INSERT INTO FA_BALANCES_REPORT_GT
1473: (Asset_ID,
1474: Distribution_CCID,
1475: Adjustment_CCID,
1476: Category_Books_Account,
1622: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1623:
1624: if ( report_type not in ('RESERVE') ) THEN
1625: if (h_reporting_flag = 'R') then
1626: INSERT INTO FA_BALANCES_REPORT_GT
1627: (Asset_ID,
1628: Distribution_CCID,
1629: Adjustment_CCID,
1630: Category_Books_Account,
1725: null),
1726: 'RESERVE', CB.Deprn_Reserve_Acct,
1727: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
1728: else
1729: INSERT INTO FA_BALANCES_REPORT_GT
1730: (Asset_ID,
1731: Distribution_CCID,
1732: Adjustment_CCID,
1733: Category_Books_Account,
1833:
1834: -- Get the Depreciation reserve begin balance
1835:
1836: if (h_reporting_flag = 'R') then
1837: INSERT INTO FA_BALANCES_REPORT_GT
1838: (Asset_ID,
1839: Distribution_CCID,
1840: Adjustment_CCID,
1841: Category_Books_Account,
1872: WHERE DD_SUB.BOOK_TYPE_CODE = book
1873: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1874: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1875: else
1876: INSERT INTO FA_BALANCES_REPORT_GT
1877: (Asset_ID,
1878: Distribution_CCID,
1879: Adjustment_CCID,
1880: Category_Books_Account,
1970: if ( nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') then
1971:
1972: IF REPORT_TYPE NOT IN ('RESERVE') THEN
1973: if (h_reporting_flag = 'R') then
1974: INSERT INTO FA_BALANCES_REPORT_GT
1975: (Asset_ID,
1976: Distribution_CCID,
1977: Adjustment_CCID,
1978: Category_Books_Account,
2070: null),
2071: 'RESERVE', CB.Deprn_Reserve_Acct,
2072: 'REVAL RESERVE', CB.Reval_Reserve_Acct) is not null;
2073: else
2074: INSERT INTO FA_BALANCES_REPORT_GT
2075: (Asset_ID,
2076: Distribution_CCID,
2077: Adjustment_CCID,
2078: Category_Books_Account,
2174:
2175: ELSE
2176:
2177: if (h_reporting_flag = 'R') then
2178: INSERT INTO FA_BALANCES_REPORT_GT
2179: (Asset_ID,
2180: Distribution_CCID,
2181: Adjustment_CCID,
2182: Category_Books_Account,
2212: WHERE DD_SUB.BOOK_TYPE_CODE = book
2213: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2214: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2215: else
2216: INSERT INTO FA_BALANCES_REPORT_GT
2217: (Asset_ID,
2218: Distribution_CCID,
2219: Adjustment_CCID,
2220: Category_Books_Account,
2297: h_reporting_flag := 'P';
2298: end if;
2299:
2300: if (h_reporting_flag = 'R') then
2301: INSERT INTO FA_BALANCES_REPORT_GT
2302: (Asset_ID,
2303: Distribution_CCID,
2304: Adjustment_CCID,
2305: Category_Books_Account,
2376: 'RESERVE', CB.Deprn_Reserve_Acct,
2377: 'REVAL RESERVE', CB.Reval_Reserve_Acct),
2378: DD.Deprn_Source_Code;
2379: else
2380: INSERT INTO FA_BALANCES_REPORT_GT
2381: (Asset_ID,
2382: Distribution_CCID,
2383: Adjustment_CCID,
2384: Category_Books_Account,
2462:
2463: -- Get the Group Depreciation Effects
2464:
2465: if (h_reporting_flag = 'R') then
2466: INSERT INTO FA_BALANCES_REPORT_GT
2467: (Asset_ID,
2468: Distribution_CCID,
2469: Adjustment_CCID,
2470: Category_Books_Account,
2495: GAD.DEPRN_RESERVE_ACCT_CCID ,
2496: null,
2497: 'DEPRECIATION' ;
2498: else
2499: INSERT INTO FA_BALANCES_REPORT_GT
2500: (Asset_ID,
2501: Distribution_CCID,
2502: Adjustment_CCID,
2503: Category_Books_Account,
2643: else
2644: Balance_Type := 'DR';
2645: end if;
2646:
2647: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2648:
2649: /*This section of code needs to be replaced due to the fact that in 11.5 the
2650: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2651: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two