[Home] [Help] [Dependency Information]
Object Name: | XDP_PARAMETER_POOL_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XDP.XDP_PARAMETER_POOL_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
MultiLingual view (a language resolved view of the data.)
This view stores the parameter base definition (i.e., name, data type, etc...) for all the parameters which are known to SFM (defined for lookup_type CSI_EXTEND_ATTRIB_POOL in CSI_LOOKUPS).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
PARAMETER_ID | VARCHAR2 | (0) | Parameter identifier | |
PARAMETER_NAME | VARCHAR2 | (30) | Yes | Name of the Parameter |
PROTECTED_FLAG | VARCHAR2 | (1) | Yes | Internal flag to indicate if the Parameter is protected or not (ie Seed Data) |
DATA_TYPE | VARCHAR2 | (0) | Data Type of the Parameter | |
DATA_LENGTH | VARCHAR2 | (0) | Data Length of the Parameter | |
DATA_FORMAT_MASK | VARCHAR2 | (0) | Format Mask of the Parameter | |
DATA_RANGE_LOW | VARCHAR2 | (0) | Low Range indicator for the Parameter | |
DATA_RANGE_HI | VARCHAR2 | (0) | High Range indicator for the Parameter | |
CREATION_DATE | VARCHAR2 | (0) | Standard WHO column | |
LAST_UPDATE_DATE | VARCHAR2 | (0) | Standard WHO column | |
LAST_UPDATED_BY | VARCHAR2 | (0) | Standard WHO column | |
CREATED_BY | VARCHAR2 | (0) | Standard WHO column | |
LAST_UPDATE_LOGIN | VARCHAR2 | (0) | Standard WHO column | |
DISPLAY_NAME | VARCHAR2 | (80) | Yes | Display Name of the Parameter |
DESCRIPTION | VARCHAR2 | (0) | Description | |
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PARAMETER_ID
, PARAMETER_NAME
, PROTECTED_FLAG
, DATA_TYPE
, DATA_LENGTH
, DATA_FORMAT_MASK
, DATA_RANGE_LOW
, DATA_RANGE_HI
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, DISPLAY_NAME
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM APPS.XDP_PARAMETER_POOL_VL;
APPS.XDP_PARAMETER_POOL_VL is not referenced by any database object
|
|
|