eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PSB_ATTRIBUTES_VL

Product:	PSB - Public Sector Budgeting (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.ROWID ROW_ID
, B.ALLOW_IN_POSITION_SET_FLAG
, B.VALUE_TABLE_FLAG
, B.APPLICATION_ID
, B.DEFINITION_TYPE
, B.ATTRIBUTE_TYPE_ID
, B.DATA_TYPE
, B.SYSTEM_ATTRIBUTE_TYPE
, B.ATTRIBUTE_ID
, B.BUSINESS_GROUP_ID
, C.NAME BUSINESS_GROUP_NAME
, B.REQUIRED_FOR_POSITIONS_FLAG
, B.REQUIRED_FOR_IMPORT_FLAG
, B.PROTECTED_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.DEFINITION_STRUCTURE
, B.DEFINITION_TABLE
, B.DEFINITION_COLUMN
, B.DISPLAY_SEQUENCE
, B.DISPLAY_IN_WORKSHEET
, T.NAME
, T.DISPLAY_PROMPT
FROM PSB_ATTRIBUTES_TL T
, PSB_ATTRIBUTES B
, PER_BUSINESS_GROUPS C
WHERE B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.BUSINESS_GROUP_ID = C.BUSINESS_GROUP_ID

Columns

Name
ROW_ID
ALLOW_IN_POSITION_SET_FLAG
VALUE_TABLE_FLAG
APPLICATION_ID
DEFINITION_TYPE
ATTRIBUTE_TYPE_ID
DATA_TYPE
SYSTEM_ATTRIBUTE_TYPE
ATTRIBUTE_ID
BUSINESS_GROUP_ID
BUSINESS_GROUP_NAME
REQUIRED_FOR_POSITIONS_FLAG
REQUIRED_FOR_IMPORT_FLAG
PROTECTED_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
DEFINITION_STRUCTURE
DEFINITION_TABLE
DEFINITION_COLUMN
DISPLAY_SEQUENCE
DISPLAY_IN_WORKSHEET
NAME
DISPLAY_PROMPT