[Home] [Help]
443: AJ.Source_Type_Code,
444: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
445: AJ.Adjustment_Amount)
446: FROM
447: FA_LOOKUPS RT,
448: FA_DISTRIBUTION_HISTORY DH,
449: FA_TRANSACTION_HEADERS TH,
450: FA_ASSET_HISTORY AH,
451: FA_ADJUSTMENTS_MRC_V AJ
518: AJ.Source_Type_Code,
519: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
520: AJ.Adjustment_Amount)
521: FROM
522: FA_LOOKUPS RT,
523: FA_DISTRIBUTION_HISTORY DH,
524: FA_TRANSACTION_HEADERS TH,
525: FA_ASSET_HISTORY AH,
526: FA_ADJUSTMENTS AJ
598: AJ.Source_Type_Code,
599: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
600: AJ.Adjustment_Amount)
601: FROM
602: FA_LOOKUPS RT,
603: FA_DISTRIBUTION_HISTORY DH,
604: FA_TRANSACTION_HEADERS TH,
605: FA_ASSET_HISTORY AH,
606: FA_ADJUSTMENTS_MRC_V AJ
679: AJ.Source_Type_Code,
680: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
681: AJ.Adjustment_Amount)
682: FROM
683: FA_LOOKUPS RT,
684: FA_DISTRIBUTION_HISTORY DH,
685: FA_TRANSACTION_HEADERS TH,
686: FA_ASSET_HISTORY AH,
687: FA_ADJUSTMENTS AJ
904: AJ.Source_Type_Code,
905: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
906: AJ.Adjustment_Amount)
907: FROM
908: FA_LOOKUPS RT,
909: FA_ADJUSTMENTS_MRC_V AJ,
910: fa_books_mrc_v bk,
911: fa_group_asset_default gad
912:
975: AJ.Source_Type_Code,
976: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
977: AJ.Adjustment_Amount)
978: FROM
979: FA_LOOKUPS RT,
980: FA_ADJUSTMENTS AJ,
981: fa_books bk,
982: fa_group_asset_default gad
983:
2287: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2288: * nvl(ADJ.adjustment_amount,0),
2289: 'REVAL RESERVE', -DD.Reval_Amortization))
2290: FROM
2291: FA_LOOKUPS_B RT,
2292: FA_CATEGORY_BOOKS CB,
2293: FA_DISTRIBUTION_HISTORY DH,
2294: FA_ASSET_HISTORY AH,
2295: FA_DEPRN_DETAIL_MRC_V DD,
2366: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2367: * nvl(ADJ.adjustment_amount,0),
2368: 'REVAL RESERVE', -DD.Reval_Amortization))
2369: FROM
2370: FA_LOOKUPS_B RT,
2371: FA_CATEGORY_BOOKS CB,
2372: FA_DISTRIBUTION_HISTORY DH,
2373: FA_ASSET_HISTORY AH,
2374: FA_DEPRN_DETAIL DD,
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
2618: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2619: performed on both tables. Changes made by cbachand, 5/25/99
2620: DELETE FROM FA_LOOKUPS
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
2618: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2619: performed on both tables. Changes made by cbachand, 5/25/99
2620: DELETE FROM FA_LOOKUPS
2621: WHERE LOOKUP_TYPE = 'REPORT TYPE';
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
2618: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2619: performed on both tables. Changes made by cbachand, 5/25/99
2620: DELETE FROM FA_LOOKUPS
2621: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2622:
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
2618: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2619: performed on both tables. Changes made by cbachand, 5/25/99
2620: DELETE FROM FA_LOOKUPS
2621: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2622:
2623: INSERT INTO FA_LOOKUPS
2624: (lookup_type,
2619: performed on both tables. Changes made by cbachand, 5/25/99
2620: DELETE FROM FA_LOOKUPS
2621: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2622:
2623: INSERT INTO FA_LOOKUPS
2624: (lookup_type,
2625: lookup_code,
2626: last_updated_by,
2627: last_update_date,
2635: Report_Type,
2636: 'Y'); */
2637:
2638:
2639: DELETE FROM FA_LOOKUPS_B
2640: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2641: AND LOOKUP_CODE = Report_Type;
2642:
2643:
2640: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2641: AND LOOKUP_CODE = Report_Type;
2642:
2643:
2644: DELETE FROM FA_LOOKUPS_TL
2645: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2646: AND LOOKUP_CODE = Report_Type;
2647:
2648: INSERT INTO FA_LOOKUPS_B
2644: DELETE FROM FA_LOOKUPS_TL
2645: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2646: AND LOOKUP_CODE = Report_Type;
2647:
2648: INSERT INTO FA_LOOKUPS_B
2649: (LOOKUP_TYPE,
2650: LOOKUP_CODE,
2651: LAST_UPDATED_BY,
2652: LAST_UPDATE_DATE,
2657: 1,
2658: SYSDATE,
2659: 'Y');
2660:
2661: INSERT INTO FA_LOOKUPS_TL
2662: (LOOKUP_TYPE,
2663: LOOKUP_CODE,
2664: MEANING,
2665: LAST_UPDATE_DATE,
2677: FROM FND_LANGUAGES L
2678: WHERE L.INSTALLED_FLAG in ('I', 'B')
2679: AND NOT EXISTS
2680: (SELECT NULL
2681: FROM FA_LOOKUPS_TL T
2682: WHERE T.LOOKUP_TYPE = 'REPORT TYPE'
2683: AND T.LOOKUP_CODE = Report_Type
2684: AND T.LANGUAGE = L.LANGUAGE_CODE);
2685: