VIEW: APPS.POR_TEMPLATE_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT ATB.ROWID AS ROW_ID, ATB.TEMPLATE_CODE AS TEMPLATE_CODE, ATB.SEQUENCE AS DISPLAY_SEQUENCE, ATB.ATTRIBUTE_CODE AS ATTRIBUTE_CODE, ATT.ATTRIBUTE_NAME AS ATTRIBUTE_NAME, ATT.DESCRIPTION AS DESCRIPTION, ATT.DEFAULT_VALUE AS DEFAULT_VALUE, ATB.FLEX_VALUE_SET_ID AS FLEX_VALUE_SET_ID, ATB.REQUIRED_FLAG AS REQUIRED_FLAG, ATB.NODE_DISPLAY_FLAG AS NODE_DISPLAY_FLAG, ATB.CREATED_BY AS CREATED_BY, ATB.CREATION_DATE AS CREATION_DATE, ATB.LAST_UPDATED_BY AS LAST_UPDATED_BY, ATB.LAST_UPDATE_DATE AS LAST_UPDATE_DATE, ATB.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN FROM POR_TEMPLATE_ATTRIBUTES_B ATB, POR_TEMPLATE_ATTRIBUTES_TL ATT WHERE ATB.ATTRIBUTE_CODE=ATT.ATTRIBUTE_CODE AND ATT.LANGUAGE=USERENV('LANG')

View Text - HTML Formatted

SELECT ATB.ROWID AS ROW_ID
, ATB.TEMPLATE_CODE AS TEMPLATE_CODE
, ATB.SEQUENCE AS DISPLAY_SEQUENCE
, ATB.ATTRIBUTE_CODE AS ATTRIBUTE_CODE
, ATT.ATTRIBUTE_NAME AS ATTRIBUTE_NAME
, ATT.DESCRIPTION AS DESCRIPTION
, ATT.DEFAULT_VALUE AS DEFAULT_VALUE
, ATB.FLEX_VALUE_SET_ID AS FLEX_VALUE_SET_ID
, ATB.REQUIRED_FLAG AS REQUIRED_FLAG
, ATB.NODE_DISPLAY_FLAG AS NODE_DISPLAY_FLAG
, ATB.CREATED_BY AS CREATED_BY
, ATB.CREATION_DATE AS CREATION_DATE
, ATB.LAST_UPDATED_BY AS LAST_UPDATED_BY
, ATB.LAST_UPDATE_DATE AS LAST_UPDATE_DATE
, ATB.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN
FROM POR_TEMPLATE_ATTRIBUTES_B ATB
, POR_TEMPLATE_ATTRIBUTES_TL ATT
WHERE ATB.ATTRIBUTE_CODE=ATT.ATTRIBUTE_CODE
AND ATT.LANGUAGE=USERENV('LANG')