VIEW: APPS.PQH_ATTRIBUTES_VL

Source

View Text - Preformatted

SELECT ATT.ROWID ROW_ID, ATT.MASTER_ATTRIBUTE_ID, ATT.ATTRIBUTE_ID, ATT.WIDTH, ATT.CREATED_BY, ATT.CREATION_DATE, ATT.LAST_UPDATED_BY, ATT.LAST_UPDATE_DATE, ATT.LAST_UPDATE_LOGIN, ATT.OBJECT_VERSION_NUMBER, ATT.ENABLE_FLAG, ATT.MASTER_TABLE_ROUTE_ID, ATT.COLUMN_NAME, ATT.COLUMN_TYPE, ATL.ATTRIBUTE_NAME, ATT.REFRESH_COL_NAME, ATT.LEGISLATION_CODE, ATT.ATTRIBUTE_ITEMNAME, ATT.REGION_ITEMNAME, ATT.DECODE_FUNCTION_NAME, att.key_column_name from PQH_ATTRIBUTES_TL ATL, PQH_ATTRIBUTES ATT WHERE ATT.ATTRIBUTE_ID = ATL.ATTRIBUTE_ID and ATL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT ATT.ROWID ROW_ID
, ATT.MASTER_ATTRIBUTE_ID
, ATT.ATTRIBUTE_ID
, ATT.WIDTH
, ATT.CREATED_BY
, ATT.CREATION_DATE
, ATT.LAST_UPDATED_BY
, ATT.LAST_UPDATE_DATE
, ATT.LAST_UPDATE_LOGIN
, ATT.OBJECT_VERSION_NUMBER
, ATT.ENABLE_FLAG
, ATT.MASTER_TABLE_ROUTE_ID
, ATT.COLUMN_NAME
, ATT.COLUMN_TYPE
, ATL.ATTRIBUTE_NAME
, ATT.REFRESH_COL_NAME
, ATT.LEGISLATION_CODE
, ATT.ATTRIBUTE_ITEMNAME
, ATT.REGION_ITEMNAME
, ATT.DECODE_FUNCTION_NAME
, ATT.KEY_COLUMN_NAME
FROM PQH_ATTRIBUTES_TL ATL
, PQH_ATTRIBUTES ATT
WHERE ATT.ATTRIBUTE_ID = ATL.ATTRIBUTE_ID
AND ATL.LANGUAGE = USERENV('LANG')