DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_PRO_PARAM

Object Details
Object Name: XTR_PRO_PARAM
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_PRO_PARAM
Subobject Name:
Status: VALID


XTR_PRO_PARAM table contains the system parameters settings. Each row defines one system parameter and its value.
This table corresponds to the System Parameter window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_PRO_PARAM_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARAM_NAME
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
DESCRIPTION VARCHAR2 (250)
Treasury system parameter description
PARAM_NAME VARCHAR2 (50) Yes Treasury system parameter name
PARAM_TYPE VARCHAR2 (7)
Treasury system parameter type
PARAM_VALUE VARCHAR2 (50)
Treasury system parameter value
UNIQUE_REF_NUM NUMBER
Yes Treasury system parameter identifier
UPDATED_BY VARCHAR2 (30)
User who last updated this record
UPDATED_ON DATE

Date this record was last updated
CREATED_BY VARCHAR2 (30) Yes User who created this record
CREATED_ON DATE
Yes Date this record was created
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUDIT_INDICATOR
,      DESCRIPTION
,      PARAM_NAME
,      PARAM_TYPE
,      PARAM_VALUE
,      UNIQUE_REF_NUM
,      UPDATED_BY
,      UPDATED_ON
,      CREATED_BY
,      CREATED_ON
,      ZD_EDITION_NAME
FROM XTR.XTR_PRO_PARAM;

Dependencies

[top of page]

XTR.XTR_PRO_PARAM does not reference any database object

XTR.XTR_PRO_PARAM is referenced by following:

SchemaXTR
ViewXTR_PRO_PARAM#