DBA Data[Home] [Help]

APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_LOOKUPS_TL

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

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

Line 2671: DELETE FROM FA_LOOKUPS_TL

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

Line 2688: INSERT INTO FA_LOOKUPS_TL

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,

Line 2708: FROM FA_LOOKUPS_TL T

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: