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

VIEW: APPS.XTR_COMPANY_PARAMETERS_V

Object Details
Object Name: XTR_COMPANY_PARAMETERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_COMPANY_PARAMETERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_PARAMETER_ID NUMBER (15) Yes Unique identifier for each row of company parameter data.
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.
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.
Query Text

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


SELECT COMPANY_PARAMETER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COMPANY_CODE
,      PARAMETER_CODE
,      PARAMETER_VALUE_CODE
,      PARAMETER_VALUE
FROM APPS.XTR_COMPANY_PARAMETERS_V;

Dependencies

[top of page]

APPS.XTR_COMPANY_PARAMETERS_V references the following:

SchemaAPPS
SynonymXTR_COMPANY_PARAMETERS
APPS.XTR_COMPANY_PARAMETERS_V is referenced by following:

SchemaAPPS
Package BodyQRM_PA_CALCULATION_P - show dependent code