POR_INFO_TEMPLATES_ALL_VL

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name
INFO_TEMPLATE_ID PRC_BU_ID INFO_TEMPLATE_CODE INFO_TEMPLATE_NAME DESCRIPTION INACTIVE_DATE DFF_CONTEXT_CODE ATTACHMENT_CATEGORY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.INFO_TEMPLATE_ID INFO_TEMPLATE_ID, B.PRC_BU_ID PRC_BU_ID, B.INFO_TEMPLATE_CODE INFO_TEMPLATE_CODE, TL.INFO_TEMPLATE_NAME INFO_TEMPLATE_NAME, TL.DESCRIPTION DESCRIPTION, B.INACTIVE_DATE INACTIVE_DATE, B.DFF_CONTEXT_CODE DFF_CONTEXT_CODE, B.ATTACHMENT_CATEGORY ATTACHMENT_CATEGORY, 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, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM POR_INFO_TEMPLATES_ALL_B B, POR_INFO_TEMPLATES_ALL_TL TL WHERE B.INFO_TEMPLATE_ID = TL.INFO_TEMPLATE_ID AND TL.LANGUAGE = USERENV('LANG')