[Home] [Help]
461: AJ.Source_Type_Code,
462: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
463: AJ.Adjustment_Amount)
464: FROM
465: FA_LOOKUPS RT,
466: FA_DISTRIBUTION_HISTORY DH,
467: FA_TRANSACTION_HEADERS TH,
468: FA_ASSET_HISTORY AH,
469: FA_ADJUSTMENTS_MRC_V AJ
536: AJ.Source_Type_Code,
537: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
538: AJ.Adjustment_Amount)
539: FROM
540: FA_LOOKUPS RT,
541: FA_DISTRIBUTION_HISTORY DH,
542: FA_TRANSACTION_HEADERS TH,
543: FA_ASSET_HISTORY AH,
544: FA_ADJUSTMENTS AJ
616: AJ.Source_Type_Code,
617: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
618: AJ.Adjustment_Amount)
619: FROM
620: FA_LOOKUPS RT,
621: FA_DISTRIBUTION_HISTORY DH,
622: FA_TRANSACTION_HEADERS TH,
623: FA_ASSET_HISTORY AH,
624: FA_ADJUSTMENTS_MRC_V AJ
697: AJ.Source_Type_Code,
698: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
699: AJ.Adjustment_Amount)
700: FROM
701: FA_LOOKUPS RT,
702: FA_DISTRIBUTION_HISTORY DH,
703: FA_TRANSACTION_HEADERS TH,
704: FA_ASSET_HISTORY AH,
705: FA_ADJUSTMENTS AJ
928: AJ.Source_Type_Code,
929: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
930: AJ.Adjustment_Amount)
931: FROM
932: FA_LOOKUPS RT,
933: FA_ADJUSTMENTS_MRC_V AJ,
934: fa_books_mrc_v bk,
935: fa_group_asset_default gad
936:
999: AJ.Source_Type_Code,
1000: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
1001: AJ.Adjustment_Amount)
1002: FROM
1003: FA_LOOKUPS RT,
1004: FA_ADJUSTMENTS AJ,
1005: fa_books bk,
1006: fa_group_asset_default gad
1007:
2342: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2343: * nvl(ADJ.adjustment_amount,0),
2344: 'REVAL RESERVE', -DD.Reval_Amortization))
2345: FROM
2346: FA_LOOKUPS_B RT,
2347: FA_CATEGORY_BOOKS CB,
2348: FA_DISTRIBUTION_HISTORY DH,
2349: FA_ASSET_HISTORY AH,
2350: FA_DEPRN_DETAIL_MRC_V DD,
2421: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2422: * nvl(ADJ.adjustment_amount,0),
2423: 'REVAL RESERVE', -DD.Reval_Amortization))
2424: FROM
2425: FA_LOOKUPS_B RT,
2426: FA_CATEGORY_BOOKS CB,
2427: FA_DISTRIBUTION_HISTORY DH,
2428: FA_ASSET_HISTORY AH,
2429: FA_DEPRN_DETAIL DD,
2670:
2671: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2672:
2673: /*This section of code needs to be replaced due to the fact that in 11.5 the
2674: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2675: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two
2676: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2677: performed on both tables. Changes made by cbachand, 5/25/99
2678: DELETE FROM FA_LOOKUPS
2671: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2672:
2673: /*This section of code needs to be replaced due to the fact that in 11.5 the
2674: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2675: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two
2676: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2677: performed on both tables. Changes made by cbachand, 5/25/99
2678: DELETE FROM FA_LOOKUPS
2679: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2672:
2673: /*This section of code needs to be replaced due to the fact that in 11.5 the
2674: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2675: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two
2676: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2677: performed on both tables. Changes made by cbachand, 5/25/99
2678: DELETE FROM FA_LOOKUPS
2679: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2680:
2674: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2675: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two
2676: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2677: performed on both tables. Changes made by cbachand, 5/25/99
2678: DELETE FROM FA_LOOKUPS
2679: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2680:
2681: INSERT INTO FA_LOOKUPS
2682: (lookup_type,
2677: performed on both tables. Changes made by cbachand, 5/25/99
2678: DELETE FROM FA_LOOKUPS
2679: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2680:
2681: INSERT INTO FA_LOOKUPS
2682: (lookup_type,
2683: lookup_code,
2684: last_updated_by,
2685: last_update_date,
2693: Report_Type,
2694: 'Y'); */
2695:
2696:
2697: DELETE FROM FA_LOOKUPS_B
2698: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2699: AND LOOKUP_CODE = Report_Type;
2700:
2701:
2698: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2699: AND LOOKUP_CODE = Report_Type;
2700:
2701:
2702: DELETE FROM FA_LOOKUPS_TL
2703: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2704: AND LOOKUP_CODE = Report_Type;
2705:
2706: INSERT INTO FA_LOOKUPS_B
2702: DELETE FROM FA_LOOKUPS_TL
2703: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2704: AND LOOKUP_CODE = Report_Type;
2705:
2706: INSERT INTO FA_LOOKUPS_B
2707: (LOOKUP_TYPE,
2708: LOOKUP_CODE,
2709: LAST_UPDATED_BY,
2710: LAST_UPDATE_DATE,
2715: 1,
2716: SYSDATE,
2717: 'Y');
2718:
2719: INSERT INTO FA_LOOKUPS_TL
2720: (LOOKUP_TYPE,
2721: LOOKUP_CODE,
2722: MEANING,
2723: LAST_UPDATE_DATE,
2735: FROM FND_LANGUAGES L
2736: WHERE L.INSTALLED_FLAG in ('I', 'B')
2737: AND NOT EXISTS
2738: (SELECT NULL
2739: FROM FA_LOOKUPS_TL T
2740: WHERE T.LOOKUP_TYPE = 'REPORT TYPE'
2741: AND T.LOOKUP_CODE = Report_Type
2742: AND T.LANGUAGE = L.LANGUAGE_CODE);
2743: