GMS_AWARD_TEMPLATES_VL

Details

• Schema: FUSION

• Object owner: GMS

• Object type: VIEW

Columns

Name

TEMPLATE_ID AWARD_HEADER_ID BUSINESS_UNIT_ID LEGAL_ENTITY_ID CURRENCY_CODE START_DATE_ACTIVE END_DATE_ACTIVE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN TEMPLATE_NAME DESCRIPTION TEMPLATE_NUMBER SOURCE_TEMPLATE_ID TEMPLATE_SOURCE BUDGET_PERIOD_COUNT BUDGET_PERIOD_FREQUENCY BUDGET_PERIOD_PREFIX BUDGET_PERIOD_SEPERATOR BUDGET_PERIOD_FORMAT CONTRACT_TYPE_ID LOC_ENABLED_FLAG DEFAULT_TEMPLATE_FLAG PROJECT_TEMPLATE_ID CONTRACT_APPROVAL_FLAG

Query

SQL_Statement

SELECT B.TEMPLATE_ID TEMPLATE_ID, B.AWARD_HEADER_ID AWARD_HEADER_ID, B.BUSINESS_UNIT_ID BUSINESS_UNIT_ID, B.LEGAL_ENTITY_ID LEGAL_ENTITY_ID, B.CURRENCY_CODE CURRENCY_CODE, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TL.TEMPLATE_NAME TEMPLATE_NAME, TL.DESCRIPTION DESCRIPTION, B.TEMPLATE_NUMBER TEMPLATE_NUMBER, B.SOURCE_TEMPLATE_ID, B.TEMPLATE_SOURCE, B.BUDGET_PERIOD_COUNT, B.BUDGET_PERIOD_FREQUENCY, B.BUDGET_PERIOD_PREFIX, B.BUDGET_PERIOD_SEPERATOR, B.BUDGET_PERIOD_FORMAT, B.CONTRACT_TYPE_ID CONTRACT_TYPE_ID, B.LOC_ENABLED_FLAG LOC_ENABLED_FLAG, B.DEFAULT_TEMPLATE_FLAG DEFAULT_TEMPLATE_FLAG, B.PROJECT_TEMPLATE_ID PROJECT_TEMPLATE_ID, B.CONTRACT_APPROVAL_FLAG FROM GMS_AWARD_TEMPLATES_B B, GMS_AWARD_TEMPLATES_TL TL WHERE B.TEMPLATE_ID = TL.TEMPLATE_ID AND TL.LANGUAGE = USERENV('LANG')