View: OKE_ATTRIBUTE_GROUPS_V

Product:	OKE - Project Contracts
Description:	View for attribute group
Implementation/DBA Data:	APPS.OKE_ATTRIBUTE_GROUPS_V

View Text

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'

Columns