[Home] [Help] [Dependency Information]
Object Name: | PSB_ATTRIBUTES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSB_ATTRIBUTES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
PSB_ATTRIBUTES_VL is a multilingual view on PSB_ATTRIBUTES and provides information about attribute definitions.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ALLOW_IN_POSITION_SET_FLAG | VARCHAR2 | (1) | ||
VALUE_TABLE_FLAG | VARCHAR2 | (1) | ||
APPLICATION_ID | NUMBER | (15) | ||
DEFINITION_TYPE | VARCHAR2 | (10) | ||
ATTRIBUTE_TYPE_ID | NUMBER | |||
DATA_TYPE | VARCHAR2 | (1) | ||
SYSTEM_ATTRIBUTE_TYPE | VARCHAR2 | (30) | ||
ATTRIBUTE_ID | NUMBER | (20) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (20) | Yes | |
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
REQUIRED_FOR_POSITIONS_FLAG | VARCHAR2 | (1) | ||
REQUIRED_FOR_IMPORT_FLAG | VARCHAR2 | (1) | ||
PROTECTED_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
DEFINITION_STRUCTURE | VARCHAR2 | (30) | ||
DEFINITION_TABLE | VARCHAR2 | (30) | ||
DEFINITION_COLUMN | VARCHAR2 | (30) | ||
DISPLAY_SEQUENCE | NUMBER | |||
DISPLAY_IN_WORKSHEET | VARCHAR2 | (1) | ||
NAME | VARCHAR2 | (30) | Yes | |
DISPLAY_PROMPT | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM APPS.PSB_ATTRIBUTES_VL;
|
|
|