APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_LOOKUPS_B

Line 2346: FA_LOOKUPS_B RT,

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,

Line 2425: FA_LOOKUPS_B RT,

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,

Line 2674: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and

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

Line 2697: DELETE FROM FA_LOOKUPS_B

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:

Line 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,