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

VIEW: APPS.OKC_FUNCTION_EXPR_PARAMS_V

Object Details
Object Name: OKC_FUNCTION_EXPR_PARAMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_FUNCTION_EXPR_PARAMS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The parameters to be supplied to a FUNCTION EXPRESSION. If of subtype ATTRIBUTE SUPPLIED, the value to be used is provided by an ACTION ATTRIBUTE. If USER SUPPLIED, then the value is entered by the user when the FUNCTION EXPRESSION PARAMETER is defined. A type of FUNCTION EXPRESSION PARAMETER indicating that the value to be passed as the parameter value is provided by an ACTION ATTRIBUTE. A type of FUNCTION EXPRESSION PARAMETER indicating that the value to be passed as the parameter value is provided by the user when the FUNCTION EXPRESSION PARAMETER is defined.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
ID NUMBER
Yes Primary key column.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
CNL_ID NUMBER
Yes Foreign key to OKC_CONDITION_LINES_B.
PDP_ID NUMBER
Yes Unique identifier of Process Definition Parameter. Refers to ID in OKC_PROCESS_DEF_PARMS_B
AAE_ID NUMBER

Unique identifier of Action Attribute. Refers to ID in OKC_ACTION_ATTRIBUTES_B.
DNZ_CHR_ID NUMBER

Contract ID. Denormalized for performance.
VALUE VARCHAR2 (2000)
User supplied value for function parameter.
APPLICATION_ID NUMBER

Application Identifier
SEEDED_FLAG VARCHAR2 (3)
Indicates whether a record is seeded 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.
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      CNL_ID
,      PDP_ID
,      AAE_ID
,      DNZ_CHR_ID
,      VALUE
,      APPLICATION_ID
,      SEEDED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_FUNCTION_EXPR_PARAMS_V;

Dependencies

[top of page]

APPS.OKC_FUNCTION_EXPR_PARAMS_V references the following:

SchemaAPPS
SynonymOKC_FUNCTION_EXPR_PARAMS
APPS.OKC_FUNCTION_EXPR_PARAMS_V is referenced by following:

SchemaAPPS
Package BodyOKC_CONDITIONS_PVT - show dependent code
Package BodyOKC_DELETE_CONTRACT_PVT - show dependent code
Package BodyOKC_FEP_PVT - show dependent code
PL/SQL PackageOKC_FEP_PVT - show dependent code
Package BodyOKC_INST_CND_PVT - show dependent code