QP_DOMAINS_VL

Details

• Schema: FUSION

• Object owner: QP

• Object type: VIEW

Columns

Name
DOMAIN_ID DOMAIN_CODE DOMAIN_SOURCE_TYPE_CODE LOOKUP_TYPE_CODE DATATYPE_CODE DISPLAY_TYPE_CODE APP_MODULE_NAME APP_MODULE_CONFIG DOMAIN_VO_NAME DOMAIN_VO_VC_NAME DOMAIN_VO_DISPLAY_ATTR_NAME NAME DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT QP_DOMAINS_B.DOMAIN_ID DOMAIN_ID, QP_DOMAINS_B.DOMAIN_CODE DOMAIN_CODE, QP_DOMAINS_B.DOMAIN_SOURCE_TYPE_CODE DOMAIN_SOURCE_TYPE_CODE, QP_DOMAINS_B.LOOKUP_TYPE_CODE LOOKUP_TYPE_CODE, QP_DOMAINS_B.DATATYPE_CODE DATATYPE_CODE, QP_DOMAINS_B.DISPLAY_TYPE_CODE DISPLAY_TYPE_CODE, QP_DOMAINS_B.APP_MODULE_NAME APP_MODULE_NAME, QP_DOMAINS_B.APP_MODULE_CONFIG APP_MODULE_CONFIG, QP_DOMAINS_B.DOMAIN_VO_NAME DOMAIN_VO_NAME, QP_DOMAINS_B.DOMAIN_VO_VC_NAME DOMAIN_VO_VC_NAME, QP_DOMAINS_B.DOMAIN_VO_DISPLAY_ATTR_NAME DOMAIN_VO_DISPLAY_ATTR_NAME, QP_DOMAINS_TL.NAME NAME, QP_DOMAINS_TL.DESCRIPTION DESCRIPTION, QP_DOMAINS_B.CREATION_DATE CREATION_DATE, QP_DOMAINS_B.CREATED_BY CREATED_BY, QP_DOMAINS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_DOMAINS_B.LAST_UPDATED_BY LAST_UPDATED_BY, QP_DOMAINS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_DOMAINS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM QP_DOMAINS_B, QP_DOMAINS_TL WHERE QP_DOMAINS_B.DOMAIN_ID = QP_DOMAINS_TL.DOMAIN_ID AND QP_DOMAINS_TL.LANGUAGE = USERENV('LANG')