根据快码的类型获取快码Lookup Code设置

根据快码的类型获取快码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';