[Home] [Help]
470: AJ.Source_Type_Code,
471: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
472: AJ.Adjustment_Amount)
473: FROM
474: FA_LOOKUPS RT,
475: FA_DISTRIBUTION_HISTORY DH,
476: FA_TRANSACTION_HEADERS TH,
477: FA_ASSET_HISTORY AH,
478: FA_ADJUSTMENTS_MRC_V AJ
545: AJ.Source_Type_Code,
546: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
547: AJ.Adjustment_Amount)
548: FROM
549: FA_LOOKUPS RT,
550: FA_DISTRIBUTION_HISTORY DH,
551: FA_TRANSACTION_HEADERS TH,
552: FA_ASSET_HISTORY AH,
553: FA_ADJUSTMENTS AJ
625: AJ.Source_Type_Code,
626: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
627: AJ.Adjustment_Amount)
628: FROM
629: FA_LOOKUPS RT,
630: FA_DISTRIBUTION_HISTORY DH,
631: FA_TRANSACTION_HEADERS TH,
632: FA_ASSET_HISTORY AH,
633: FA_ADJUSTMENTS_MRC_V AJ
706: AJ.Source_Type_Code,
707: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
708: AJ.Adjustment_Amount)
709: FROM
710: FA_LOOKUPS RT,
711: FA_DISTRIBUTION_HISTORY DH,
712: FA_TRANSACTION_HEADERS TH,
713: FA_ASSET_HISTORY AH,
714: FA_ADJUSTMENTS AJ
931: AJ.Source_Type_Code,
932: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
933: AJ.Adjustment_Amount)
934: FROM
935: FA_LOOKUPS RT,
936: FA_ADJUSTMENTS_MRC_V AJ,
937: fa_books_mrc_v bk,
938: fa_group_asset_default gad
939:
1002: AJ.Source_Type_Code,
1003: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
1004: AJ.Adjustment_Amount)
1005: FROM
1006: FA_LOOKUPS RT,
1007: FA_ADJUSTMENTS AJ,
1008: fa_books bk,
1009: fa_group_asset_default gad
1010:
2314: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2315: * nvl(ADJ.adjustment_amount,0),
2316: 'REVAL RESERVE', -DD.Reval_Amortization))
2317: FROM
2318: FA_LOOKUPS_B RT,
2319: FA_CATEGORY_BOOKS CB,
2320: FA_DISTRIBUTION_HISTORY DH,
2321: FA_ASSET_HISTORY AH,
2322: FA_DEPRN_DETAIL_MRC_V DD,
2393: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2394: * nvl(ADJ.adjustment_amount,0),
2395: 'REVAL RESERVE', -DD.Reval_Amortization))
2396: FROM
2397: FA_LOOKUPS_B RT,
2398: FA_CATEGORY_BOOKS CB,
2399: FA_DISTRIBUTION_HISTORY DH,
2400: FA_ASSET_HISTORY AH,
2401: FA_DEPRN_DETAIL DD,
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
2645: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2646: performed on both tables. Changes made by cbachand, 5/25/99
2647: DELETE FROM FA_LOOKUPS
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
2645: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2646: performed on both tables. Changes made by cbachand, 5/25/99
2647: DELETE FROM FA_LOOKUPS
2648: WHERE LOOKUP_TYPE = 'REPORT TYPE';
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
2645: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2646: performed on both tables. Changes made by cbachand, 5/25/99
2647: DELETE FROM FA_LOOKUPS
2648: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2649:
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
2645: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2646: performed on both tables. Changes made by cbachand, 5/25/99
2647: DELETE FROM FA_LOOKUPS
2648: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2649:
2650: INSERT INTO FA_LOOKUPS
2651: (lookup_type,
2646: performed on both tables. Changes made by cbachand, 5/25/99
2647: DELETE FROM FA_LOOKUPS
2648: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2649:
2650: INSERT INTO FA_LOOKUPS
2651: (lookup_type,
2652: lookup_code,
2653: last_updated_by,
2654: last_update_date,
2662: Report_Type,
2663: 'Y'); */
2664:
2665:
2666: DELETE FROM FA_LOOKUPS_B
2667: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2668: AND LOOKUP_CODE = Report_Type;
2669:
2670:
2667: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2668: AND LOOKUP_CODE = Report_Type;
2669:
2670:
2671: DELETE FROM FA_LOOKUPS_TL
2672: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2673: AND LOOKUP_CODE = Report_Type;
2674:
2675: INSERT INTO FA_LOOKUPS_B
2671: DELETE FROM FA_LOOKUPS_TL
2672: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2673: AND LOOKUP_CODE = Report_Type;
2674:
2675: INSERT INTO FA_LOOKUPS_B
2676: (LOOKUP_TYPE,
2677: LOOKUP_CODE,
2678: LAST_UPDATED_BY,
2679: LAST_UPDATE_DATE,
2684: 1,
2685: SYSDATE,
2686: 'Y');
2687:
2688: INSERT INTO FA_LOOKUPS_TL
2689: (LOOKUP_TYPE,
2690: LOOKUP_CODE,
2691: MEANING,
2692: LAST_UPDATE_DATE,
2704: FROM FND_LANGUAGES L
2705: WHERE L.INSTALLED_FLAG in ('I', 'B')
2706: AND NOT EXISTS
2707: (SELECT NULL
2708: FROM FA_LOOKUPS_TL T
2709: WHERE T.LOOKUP_TYPE = 'REPORT TYPE'
2710: AND T.LOOKUP_CODE = Report_Type
2711: AND T.LANGUAGE = L.LANGUAGE_CODE);
2712: