VIEW: APPS.OKE_ATTRIBUTE_GROUPS_V

Source

View Text - Preformatted

SELECT 'SYSTEM' , LOOKUP_CODE , MEANING , DESCRIPTION , START_DATE_ACTIVE , END_DATE_ACTIVE , ENABLED_FLAG FROM FND_LOOKUP_VALUES_VL WHERE LOOKUP_TYPE = 'ATTRIBUTE_GROUP' AND VIEW_APPLICATION_ID = 777 UNION SELECT 'USER' , DESCRIPTIVE_FLEX_CONTEXT_CODE , DESCRIPTIVE_FLEX_CONTEXT_NAME , DESCRIPTION , TO_DATE(NULL) , TO_DATE(NULL) , ENABLED_FLAG FROM FND_DESCR_FLEX_CONTEXTS_VL WHERE APPLICATION_ID = 777 AND DESCRIPTIVE_FLEXFIELD_NAME = 'OKE_K_USER_ATTRIBUTES' AND GLOBAL_FLAG = 'N'

View Text - HTML Formatted

SELECT 'SYSTEM'
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ENABLED_FLAG
FROM FND_LOOKUP_VALUES_VL
WHERE LOOKUP_TYPE = 'ATTRIBUTE_GROUP'
AND VIEW_APPLICATION_ID = 777 UNION SELECT 'USER'
, DESCRIPTIVE_FLEX_CONTEXT_CODE
, DESCRIPTIVE_FLEX_CONTEXT_NAME
, DESCRIPTION
, TO_DATE(NULL)
, TO_DATE(NULL)
, ENABLED_FLAG
FROM FND_DESCR_FLEX_CONTEXTS_VL
WHERE APPLICATION_ID = 777
AND DESCRIPTIVE_FLEXFIELD_NAME = 'OKE_K_USER_ATTRIBUTES'
AND GLOBAL_FLAG = 'N'