DBA Data[Home] [Help]

APPS.FA_FASCOSTD_XMLP_PKG dependencies on FA_LOOKUPS_TL

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

2613: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2614:
2615: /*This section of code needs to be replaced due to the fact that in 11.5 the
2616: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2617: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two
2618: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2619: performed on both tables. Changes made by cbachand, 5/25/99
2620: DELETE FROM FA_LOOKUPS
2621: WHERE LOOKUP_TYPE = 'REPORT TYPE';

Line 2644: DELETE FROM FA_LOOKUPS_TL

2640: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2641: AND LOOKUP_CODE = Report_Type;
2642:
2643:
2644: DELETE FROM FA_LOOKUPS_TL
2645: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2646: AND LOOKUP_CODE = Report_Type;
2647:
2648: INSERT INTO FA_LOOKUPS_B

Line 2661: INSERT INTO FA_LOOKUPS_TL

2657: 1,
2658: SYSDATE,
2659: 'Y');
2660:
2661: INSERT INTO FA_LOOKUPS_TL
2662: (LOOKUP_TYPE,
2663: LOOKUP_CODE,
2664: MEANING,
2665: LAST_UPDATE_DATE,

Line 2681: FROM FA_LOOKUPS_TL T

2677: FROM FND_LANGUAGES L
2678: WHERE L.INSTALLED_FLAG in ('I', 'B')
2679: AND NOT EXISTS
2680: (SELECT NULL
2681: FROM FA_LOOKUPS_TL T
2682: WHERE T.LOOKUP_TYPE = 'REPORT TYPE'
2683: AND T.LOOKUP_CODE = Report_Type
2684: AND T.LANGUAGE = L.LANGUAGE_CODE);
2685: