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

TABLE: XTR.XTR_A_COMPANY_PARAMETERS

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


Whenever an existing record in Xtr_Company_Parameters is updated the record before update is copied to Xtr_A_Company_Parameters.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
COMPANY_PARAMETER_ID NUMBER
Yes Unique identifier for each row of company parameter data.
COMPANY_CODE VARCHAR2 (7) Yes Specifies which company this data belongs to.
PARAMETER_CODE VARCHAR2 (30) Yes A code that identifies the parameter value.
PARAMETER_VALUE_CODE VARCHAR2 (30)
A code that identifies the parameter value.
PARAMETER_VALUE VARCHAR2 (240)
The parameter value. This column is used when the parameters are not seeded but are entered by the user, e.g. Subscriber FX Match ID.
CREATED_BY NUMBER (15) Yes Standard Who Column.
CREATION_DATE DATE
Yes Standard Who Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column.
LAST_UPDATE_DATE DATE
Yes Standard Who Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column.
AUDIT_DATE_STORED DATE

Audit Column
Query Text

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


SELECT COMPANY_PARAMETER_ID
,      COMPANY_CODE
,      PARAMETER_CODE
,      PARAMETER_VALUE_CODE
,      PARAMETER_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      AUDIT_DATE_STORED
FROM XTR.XTR_A_COMPANY_PARAMETERS;

Dependencies

[top of page]

XTR.XTR_A_COMPANY_PARAMETERS does not reference any database object

XTR.XTR_A_COMPANY_PARAMETERS is referenced by following:

SchemaXTR
ViewXTR_A_COMPANY_PARAMETERS#