eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKC.OKC_FUNCTION_EXPR_PARAMS

Object Details

Object Name:	OKC_FUNCTION_EXPR_PARAMS
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_FUNCTION_EXPR_PARAMS
Subobject Name:
Status:	VALID

The parameter values to be supplied for the function in a CONDITION LINE.
This may either carry the AAE_ID, indicating which ACTION ATTRIBUTE will hold the value to pass, or VALUE, which is the actual value supplied by the user when defining the CONDITION LINE.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_FUNCTION_EXPR_PARAMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKC_FUNCTION_EXPR_PARAMS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CNL_ID PDP_ID
OKC_FUNCTION_EXPR_PARAMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DNZ_CHR_ID
OKC_FUNCTION_EXPR_PARAMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AAE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	System generated Unique Identifier.
CNL_ID	NUMBER		Yes	Unique identifier of Condition Line. Refers to ID in OKC_CONDITION_LINES_B These are the parameters for the function associated with the Condition Line for CNL_TYPE=FEX
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.
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.
VALUE	VARCHAR2	(2000)		User supplied value for function parameter.
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.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
APPLICATION_ID	NUMBER			Application Identifier
SEEDED_FLAG	VARCHAR2	(3)		Indicates whether a record is seeded. Valid values Y or N.

Query Text

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


SELECT ID
,      CNL_ID
,      PDP_ID
,      AAE_ID
,      DNZ_CHR_ID
,      OBJECT_VERSION_NUMBER
,      VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      APPLICATION_ID
,      SEEDED_FLAG
FROM OKC.OKC_FUNCTION_EXPR_PARAMS;

Dependencies

[top of page]

OKC.OKC_FUNCTION_EXPR_PARAMS does not reference any database object

OKC.OKC_FUNCTION_EXPR_PARAMS is referenced by following:

APPS: OKC_FUNCTION_EXPR_PARAMS