1. Tables and Views for Sales and Fusion Service
  2. MKL_LOOKUPS

MKL_LOOKUPS

Details

  • Schema: FUSION

  • Object owner: MKL

  • Object type: VIEW

Columns

Name

LOOKUP_TYPE

LANGUAGE

LOOKUP_CODE

MEANING

DESCRIPTION

VIEW_APPLICATION_ID

SET_ID

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

SOURCE_LANG

TERRITORY_CODE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

TAG

DISPLAY_SEQUENCE

Query

SQL_Statement

select B.LOOKUP_TYPE,T.LANGUAGE, B.LOOKUP_CODE,T.MEANING,T.DESCRIPTION,B.VIEW_APPLICATION_ID,

B.SET_ID,

B.ENABLED_FLAG,

B.START_DATE_ACTIVE,

B.END_DATE_ACTIVE,

T.CREATED_BY,

T.CREATION_DATE,

T.LAST_UPDATE_DATE,

T.LAST_UPDATED_BY,

T.LAST_UPDATE_LOGIN,

T.SOURCE_LANG,

B.TERRITORY_CODE,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.TAG,

B.DISPLAY_SEQUENCE

from FND_LOOKUP_VALUES_TL T, FND_LOOKUP_VALUES_B B, fnd_lookup_types lt

where T.LOOKUP_TYPE = B.LOOKUP_TYPE

and T.LOOKUP_CODE = B.LOOKUP_CODE

and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID

and T.SET_ID = B.SET_ID

AND T.LANGUAGE = USERENV('LANG')

and B.VIEW_APPLICATION_ID IN (0, 2)

and b.lookup_type = lt.lookup_type

and b.view_application_id = lt.view_application_id

and lt.module_id in (select module_id from fnd_appl_taxonomy where

module_name in

(

'MklLeads', 'MklSalesPredictor'

))