DBA Data[Home] [Help]

APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_LOOKUPS_TL

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

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

Line 2678: DELETE FROM FA_LOOKUPS_TL

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

Line 2695: INSERT INTO FA_LOOKUPS_TL

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,

Line 2715: FROM FA_LOOKUPS_TL T

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: