DBA Data[Home] [Help]

APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_LOOKUPS_TL

Line 2675: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two

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';

Line 2702: DELETE FROM FA_LOOKUPS_TL

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

Line 2719: INSERT INTO FA_LOOKUPS_TL

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,

Line 2739: FROM FA_LOOKUPS_TL T

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: