[Home] [Help]
437: AJ.Source_Type_Code,
438: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
439: AJ.Adjustment_Amount)
440: FROM
441: FA_LOOKUPS RT,
442: FA_DISTRIBUTION_HISTORY DH,
443: FA_TRANSACTION_HEADERS TH,
444: FA_ASSET_HISTORY AH,
445: FA_ADJUSTMENTS_MRC_V AJ
512: AJ.Source_Type_Code,
513: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
514: AJ.Adjustment_Amount)
515: FROM
516: FA_LOOKUPS RT,
517: FA_DISTRIBUTION_HISTORY DH,
518: FA_TRANSACTION_HEADERS TH,
519: FA_ASSET_HISTORY AH,
520: FA_ADJUSTMENTS AJ
592: AJ.Source_Type_Code,
593: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
594: AJ.Adjustment_Amount)
595: FROM
596: FA_LOOKUPS RT,
597: FA_DISTRIBUTION_HISTORY DH,
598: FA_TRANSACTION_HEADERS TH,
599: FA_ASSET_HISTORY AH,
600: FA_ADJUSTMENTS_MRC_V AJ
673: AJ.Source_Type_Code,
674: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
675: AJ.Adjustment_Amount)
676: FROM
677: FA_LOOKUPS RT,
678: FA_DISTRIBUTION_HISTORY DH,
679: FA_TRANSACTION_HEADERS TH,
680: FA_ASSET_HISTORY AH,
681: 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:
2318: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2319: * nvl(ADJ.adjustment_amount,0),
2320: 'REVAL RESERVE', -DD.Reval_Amortization))
2321: FROM
2322: FA_LOOKUPS_B RT,
2323: FA_CATEGORY_BOOKS CB,
2324: FA_DISTRIBUTION_HISTORY DH,
2325: FA_ASSET_HISTORY AH,
2326: FA_DEPRN_DETAIL_MRC_V DD,
2397: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2398: * nvl(ADJ.adjustment_amount,0),
2399: 'REVAL RESERVE', -DD.Reval_Amortization))
2400: FROM
2401: FA_LOOKUPS_B RT,
2402: FA_CATEGORY_BOOKS CB,
2403: FA_DISTRIBUTION_HISTORY DH,
2404: FA_ASSET_HISTORY AH,
2405: FA_DEPRN_DETAIL DD,
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
2652: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2653: performed on both tables. Changes made by cbachand, 5/25/99
2654: DELETE FROM FA_LOOKUPS
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
2652: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2653: performed on both tables. Changes made by cbachand, 5/25/99
2654: DELETE FROM FA_LOOKUPS
2655: WHERE LOOKUP_TYPE = 'REPORT TYPE';
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
2652: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2653: performed on both tables. Changes made by cbachand, 5/25/99
2654: DELETE FROM FA_LOOKUPS
2655: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2656:
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
2652: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2653: performed on both tables. Changes made by cbachand, 5/25/99
2654: DELETE FROM FA_LOOKUPS
2655: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2656:
2657: INSERT INTO FA_LOOKUPS
2658: (lookup_type,
2653: performed on both tables. Changes made by cbachand, 5/25/99
2654: DELETE FROM FA_LOOKUPS
2655: WHERE LOOKUP_TYPE = 'REPORT TYPE';
2656:
2657: INSERT INTO FA_LOOKUPS
2658: (lookup_type,
2659: lookup_code,
2660: last_updated_by,
2661: last_update_date,
2669: Report_Type,
2670: 'Y'); */
2671:
2672:
2673: DELETE FROM FA_LOOKUPS_B
2674: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2675: AND LOOKUP_CODE = Report_Type;
2676:
2677:
2674: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2675: AND LOOKUP_CODE = Report_Type;
2676:
2677:
2678: DELETE FROM FA_LOOKUPS_TL
2679: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2680: AND LOOKUP_CODE = Report_Type;
2681:
2682: INSERT INTO FA_LOOKUPS_B
2678: DELETE FROM FA_LOOKUPS_TL
2679: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2680: AND LOOKUP_CODE = Report_Type;
2681:
2682: INSERT INTO FA_LOOKUPS_B
2683: (LOOKUP_TYPE,
2684: LOOKUP_CODE,
2685: LAST_UPDATED_BY,
2686: LAST_UPDATE_DATE,
2691: 1,
2692: SYSDATE,
2693: 'Y');
2694:
2695: INSERT INTO FA_LOOKUPS_TL
2696: (LOOKUP_TYPE,
2697: LOOKUP_CODE,
2698: MEANING,
2699: LAST_UPDATE_DATE,
2711: FROM FND_LANGUAGES L
2712: WHERE L.INSTALLED_FLAG in ('I', 'B')
2713: AND NOT EXISTS
2714: (SELECT NULL
2715: FROM FA_LOOKUPS_TL T
2716: WHERE T.LOOKUP_TYPE = 'REPORT TYPE'
2717: AND T.LOOKUP_CODE = Report_Type
2718: AND T.LANGUAGE = L.LANGUAGE_CODE);
2719: