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

VIEW: APPS.PSP_AUTO_PARAMS_V

Object Details
Object Name: PSP_AUTO_PARAMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSP.PSP_AUTO_PARAMS_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
ROW_ID ROWID (10)
Row Identifier
ACCT_ID NUMBER (10) Yes Autopopulation Account Identifier
PARAM_LINE_NUM NUMBER (3) Yes Internal Sequence used in Parameter Ordering
LOOKUP_ID NUMBER (10) Yes Lookup Identifier
PARAMETER_CLASS VARCHAR2 (50) Yes Parameter Class used to define autopopulation rules
PARAMETER VARCHAR2 (50) Yes The parameter used to define autopopulation rules
DATATYPE VARCHAR2 (20) Yes Data type of the parameter
VALIDATION_TYPE VARCHAR2 (1) Yes Validation Type for Autopopulation
OPERAND VARCHAR2 (20) Yes Operand used to define the parameter expressions
USER_VALUE VARCHAR2 (80)
value used for comparision with parameter
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
Query Text

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


SELECT ROW_ID
,      ACCT_ID
,      PARAM_LINE_NUM
,      LOOKUP_ID
,      PARAMETER_CLASS
,      PARAMETER
,      DATATYPE
,      VALIDATION_TYPE
,      OPERAND
,      USER_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSP_AUTO_PARAMS_V;

Dependencies

[top of page]

APPS.PSP_AUTO_PARAMS_V references the following:

SchemaAPPS
SynonymPSP_AUTO_LOOKUPS
SynonymPSP_AUTO_PARAMS

APPS.PSP_AUTO_PARAMS_V is not referenced by any database object