Product: | PQH - Public Sector HR |
---|---|
Description: | Attributes View |
Implementation/DBA Data: | APPS.PQH_ATTRIBUTES_VL |
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
FROM PQH_ATTRIBUTES_TL ATL
, PQH_ATTRIBUTES ATT
WHERE ATT.ATTRIBUTE_ID = ATL.ATTRIBUTE_ID
AND ATL.LANGUAGE = USERENV('LANG')