MKT_LOOKUP_TYPES
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: VIEW
Columns
Name |
---|
VIEW_APPLICATION_ID LOOKUP_TYPE MODULE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN MEANING DESCRIPTION |
Query
SQL_Statement |
---|
SELECT B.VIEW_APPLICATION_ID, B.LOOKUP_TYPE, B.MODULE_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, T.MEANING, T.DESCRIPTION FROM FND_LOOKUP_TYPES_TL T, FND_LOOKUP_TYPES B WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE AND T.LANGUAGE = userenv('LANG') AND T.VIEW_APPLICATION_ID = '0' and b.module_id in ( select module_id from fnd_appl_taxonomy where module_name in ( 'MktBi','MktCommonMarketing','MktCoreMarketing','MktESDClient','MktResponse','MktSalesCampaigns','MktSearchMarketing','MktSMSClient' ) ) |