[Home] [Help]
182: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N') THEN
183:
184: IF (h_reporting_flag = 'R') THEN
185: /* Bug 7498880: Added new query for upgraded periods */
186: INSERT INTO fa_balances_reports_itf
187: (asset_id,
188: distribution_ccid,
189: adjustment_ccid,
190: category_books_account,
293: aj.source_type_code;
294:
295: ELSE
296: /* Bug 7498880: Added new query for upgraded periods */
297: INSERT INTO fa_balances_reports_itf
298: (asset_id,
299: distribution_ccid,
300: adjustment_ccid,
301: category_books_account,
411: ELSIF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
412:
413: IF (h_reporting_flag = 'R') THEN
414: /* Bug 7498880: Added new query for upgraded periods */
415: INSERT INTO fa_balances_reports_itf
416: (asset_id,
417: distribution_ccid,
418: adjustment_ccid,
419: category_books_account,
541: aj.source_type_code;
542:
543: ELSE
544: /* Bug 7498880: Added new query for upgraded periods */
545: INSERT INTO fa_balances_reports_itf
546: (asset_id,
547: distribution_ccid,
548: adjustment_ccid,
549: category_books_account,
676: END IF;
677:
678: IF report_type = 'RESERVE' THEN
679: IF (h_reporting_flag = 'R') THEN
680: INSERT INTO fa_balances_reports_itf
681: (asset_id,
682: distribution_ccid,
683: adjustment_ccid,
684: category_books_account,
697: fa_asset_history ah,
698: fa_deprn_detail_mrc_v dd
699: WHERE NOT EXISTS
700: (SELECT asset_id
701: FROM fa_balances_reports_itf
702: WHERE asset_id = dh.asset_id
703: AND distribution_ccid = dh.code_combination_id
704: AND source_type_code = 'ADDITION'
705: AND request_id = h_request_id)
719: GROUP BY dh.asset_id,
720: dh.code_combination_id,
721: cb.deprn_reserve_acct;
722: ELSE
723: INSERT INTO fa_balances_reports_itf
724: (asset_id,
725: distribution_ccid,
726: adjustment_ccid,
727: category_books_account,
741: fa_book_controls bc,
742: fa_deprn_detail dd
743: WHERE NOT EXISTS
744: (SELECT asset_id
745: FROM fa_balances_reports_itf
746: WHERE asset_id = dh.asset_id
747: AND distribution_ccid = dh.code_combination_id
748: AND source_type_code = 'ADDITION'
749: AND request_id = h_request_id)
820: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
821:
822: IF (h_reporting_flag = 'R') THEN
823: /* Bug 7498880: Added new query for upgraded periods */
824: INSERT INTO fa_balances_reports_itf
825: (asset_id,
826: distribution_ccid,
827: adjustment_ccid,
828: category_books_account,
945: lines.code_combination_id /*AJ.Code_Combination_ID*/),
946: aj.source_type_code;
947: ELSE
948: /* Bug 7498880: Added new query for upgraded periods */
949: INSERT INTO fa_balances_reports_itf
950: (asset_id,
951: distribution_ccid,
952: adjustment_ccid,
953: category_books_account,
1128: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N') THEN
1129:
1130: IF (h_reporting_flag = 'R') THEN
1131:
1132: INSERT INTO fa_balances_reports_itf
1133: (asset_id,
1134: distribution_ccid,
1135: adjustment_ccid,
1136: category_books_account,
1235: ELSE
1236: -- split for 'COST','CIP COST' and 'RESERVE','REVAL RESERVE' for better performance.
1237:
1238: IF report_type IN ('COST', 'CIP COST') THEN
1239: INSERT INTO fa_balances_reports_itf
1240: (asset_id,
1241: distribution_ccid,
1242: adjustment_ccid,
1243: category_books_account,
1342: ELSE
1343: -- report_type in ('RESERVE','REVAL RESERVE')
1344:
1345: /* Bug 6998035 */
1346: INSERT INTO fa_balances_reports_itf
1347: (asset_id,
1348: distribution_ccid,
1349: adjustment_ccid,
1350: category_books_account,
1443: -- Fix for Bug #1892406. Run only if CRL installed.
1444: ELSIF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
1445:
1446: IF (h_reporting_flag = 'R') THEN
1447: INSERT INTO fa_balances_reports_itf
1448: (asset_id,
1449: distribution_ccid,
1450: adjustment_ccid,
1451: category_books_account,
1550: cb.reval_reserve_acct) IS NOT NULL
1551: -- start of CUA - This is to exclude the Group Asset Members
1552: AND bk.group_asset_id IS NULL;
1553: ELSE
1554: INSERT INTO fa_balances_reports_itf
1555: (asset_id,
1556: distribution_ccid,
1557: adjustment_ccid,
1558: category_books_account,
1708: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
1709:
1710: IF (report_type NOT IN ('RESERVE')) THEN
1711: IF (h_reporting_flag = 'R') THEN
1712: INSERT INTO fa_balances_reports_itf
1713: (asset_id,
1714: distribution_ccid,
1715: adjustment_ccid,
1716: category_books_account,
1820: cb.deprn_reserve_acct,
1821: 'REVAL RESERVE',
1822: cb.reval_reserve_acct) IS NOT NULL;
1823: ELSE
1824: INSERT INTO fa_balances_reports_itf
1825: (asset_id,
1826: distribution_ccid,
1827: adjustment_ccid,
1828: category_books_account,
1937:
1938: -- Get the Depreciation reserve begin balance
1939:
1940: IF (h_reporting_flag = 'R') THEN
1941: INSERT INTO fa_balances_reports_itf
1942: (asset_id,
1943: distribution_ccid,
1944: adjustment_ccid,
1945: category_books_account,
1976: WHERE dd_sub.book_type_code = book
1977: AND dd_sub.asset_id = gar.group_asset_id
1978: AND dd_sub.period_counter <= period_pc);
1979: ELSE
1980: INSERT INTO fa_balances_reports_itf
1981: (asset_id,
1982: distribution_ccid,
1983: adjustment_ccid,
1984: category_books_account,
2066: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
2067:
2068: IF report_type NOT IN ('RESERVE') THEN
2069: IF (h_reporting_flag = 'R') THEN
2070: INSERT INTO fa_balances_reports_itf
2071: (asset_id,
2072: distribution_ccid,
2073: adjustment_ccid,
2074: category_books_account,
2175: cb.deprn_reserve_acct,
2176: 'REVAL RESERVE',
2177: cb.reval_reserve_acct) IS NOT NULL;
2178: ELSE
2179: INSERT INTO fa_balances_reports_itf
2180: (asset_id,
2181: distribution_ccid,
2182: adjustment_ccid,
2183: category_books_account,
2288:
2289: ELSE
2290:
2291: IF (h_reporting_flag = 'R') THEN
2292: INSERT INTO fa_balances_reports_itf
2293: (asset_id,
2294: distribution_ccid,
2295: adjustment_ccid,
2296: category_books_account,
2326: WHERE dd_sub.book_type_code = book
2327: AND dd_sub.asset_id = gar.group_asset_id
2328: AND dd_sub.period_counter <= period_pc);
2329: ELSE
2330: INSERT INTO fa_balances_reports_itf
2331: (asset_id,
2332: distribution_ccid,
2333: adjustment_ccid,
2334: category_books_account,
2404: h_reporting_flag := 'P';
2405: END IF;
2406:
2407: IF (h_reporting_flag = 'R') THEN
2408: INSERT INTO fa_balances_reports_itf
2409: (asset_id,
2410: distribution_ccid,
2411: adjustment_ccid,
2412: category_books_account,
2484: 'REVAL RESERVE',
2485: cb.reval_reserve_acct),
2486: dd.deprn_source_code;
2487: ELSE
2488: INSERT INTO fa_balances_reports_itf
2489: (asset_id,
2490: distribution_ccid,
2491: adjustment_ccid,
2492: category_books_account,
2572:
2573: -- Get the Group Depreciation Effects
2574:
2575: IF (h_reporting_flag = 'R') THEN
2576: INSERT INTO fa_balances_reports_itf
2577: (asset_id,
2578: distribution_ccid,
2579: adjustment_ccid,
2580: category_books_account,
2603: gad.deprn_reserve_acct_ccid,
2604: NULL,
2605: 'DEPRECIATION';
2606: ELSE
2607: INSERT INTO fa_balances_reports_itf
2608: (asset_id,
2609: distribution_ccid,
2610: adjustment_ccid,
2611: category_books_account,