根据快码的类型获取快码Lookup Code设置
在EBS系统中,值列表的来源有时候是值集,有时候是使用快码。下面介绍如何根据快码的类型,获取快码可以有的值。
SELECT B.APPLICATION_ID,
B.LOOKUP_TYPE,
V.LOOKUP_CODE,
V.MEANING,
V.DESCRIPTION,
V.TAG,
V.ATTRIBUTE_CATEGORY,
V.ATTRIBUTE1,
V.ATTRIBUTE2
FROM FND_LOOKUP_TYPES_TL T, FND_LOOKUP_TYPES B, FND_LOOKUP_VALUES V
WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE
AND B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
AND T.LOOKUP_TYPE = V.LOOKUP_TYPE
AND V.LANGUAGE = USERENV('LANG')
AND B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.LOOKUP_TYPE = 'CREDIT_CHECK_STATUS';