[Home] [Help] [Dependency Information]
Object Name: | XTR_A_COMPANY_PARAMETERS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
XTR.XTR_A_COMPANY_PARAMETERS does not reference any database object
XTR.XTR_A_COMPANY_PARAMETERS is referenced by following:
|
|
|