PAY_CONTEXT_USAGES_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
CONTEXT_USAGE_ID CONTEXT_ID DISPLAY_CONTEXT_NAME DESCRIPTION LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID CONTEXT_ABBR INPUT_VALUE_CONTEXT_FLAG USED_IN_BALANCE_FLAG USED_IN_DIST_COSTING_FLAG LOOKUP_TYPE VO_NAME DEFAULT_VALUE_DBI_ID MEANING_DBI_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN MODULE_ID SGUID

Query

SQL_Statement

SELECT pcu.CONTEXT_USAGE_ID CONTEXT_USAGE_ID, pcu.CONTEXT_ID CONTEXT_ID, pcutl.DISPLAY_CONTEXT_NAME DISPLAY_CONTEXT_NAME, pcutl.DESCRIPTION DESCRIPTION, pcu.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pcu.LEGISLATION_CODE LEGISLATION_CODE, pcu.ENTERPRISE_ID ENTERPRISE_ID, pcu.CONTEXT_ABBR CONTEXT_ABBR, pcu.INPUT_VALUE_CONTEXT_FLAG INPUT_VALUE_CONTEXT_FLAG, pcu.USED_IN_BALANCE_FLAG USED_IN_BALANCE_FLAG, pcu.USED_IN_DIST_COSTING_FLAG USED_IN_DIST_COSTING_FLAG, pcu.LOOKUP_TYPE LOOKUP_TYPE, pcu.VO_NAME VO_NAME, pcu.DEFAULT_VALUE_DBI_ID DEFAULT_VALUE_DBI_ID, pcu.MEANING_DBI_ID MEANING_DBI_ID, pcu.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pcu.CREATED_BY CREATED_BY, pcu.CREATION_DATE CREATION_DATE, pcu.LAST_UPDATE_DATE LAST_UPDATE_DATE, pcu.LAST_UPDATED_BY LAST_UPDATED_BY, pcu.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pcu.MODULE_ID MODULE_ID, pcu.SGUID SGUID FROM PAY_CONTEXT_USAGES pcu, PAY_CONTEXT_USAGES_TL pcutl WHERE pcutl.CONTEXT_USAGE_ID = pcu.CONTEXT_USAGE_ID AND pcutl.LANGUAGE = USERENV('LANG')