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]

VIEW: APPS.OKC_OUTCOME_ARGUMENTS_V

Object Details

Object Name:	OKC_OUTCOME_ARGUMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKC.OKC_OUTCOME_ARGUMENTS_V
Subobject Name:
Status:	VALID

View Type

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

ARGUMENT, actual values, supplied to an parameters for an invocation of an OUTCOME_DEF
may be supplied
a) in a hardcoded fashion, where a set number of values of ARGUMENT are supplied to any
invoked OUTCOME DEF by code
b) flexibly by user, where OUTCOME DEF PARAMETER may be defined by user and values of ARGUMENT as
i) literals
ii) rowid "looked up" (parameter would have to know table and column
(and perhaps filtering criteria) and the user looks up rowid
iii) a tokenised, named value which encodes a table and column, and the rowid (or at least
the filtering criteria) are known implicitly by the system (eg. "CONTRACT NUMBER"
means "this" or "current" contract number
a) is the current intended solution

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		The address of the row in the database
ID	NUMBER		Yes	Primary key column.
PDP_ID	NUMBER		Yes	Foreign key to OKC_PROCESS_DEF_PARMS_B.
OCE_ID	NUMBER		Yes	Unique identifier of Outcome. Refers to ID in OKC_OUTCOMES_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)		Parameter value.
APPLICATION_ID	NUMBER			Application Identifier
SEEDED_FLAG	VARCHAR2	(3)		Indicates whether a record is seeded. Valid values are Y or N.
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
,      PDP_ID
,      OCE_ID
,      AAE_ID
,      DNZ_CHR_ID
,      OBJECT_VERSION_NUMBER
,      VALUE
,      APPLICATION_ID
,      SEEDED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_OUTCOME_ARGUMENTS_V;

Dependencies

[top of page]

APPS.OKC_OUTCOME_ARGUMENTS_V references the following:

APPS: OKC_OUTCOME_ARGUMENTS

APPS.OKC_OUTCOME_ARGUMENTS_V is referenced by following:

APPS: OKC_COPY_CONTRACT_PVT - show dependent code; OKC_DELETE_CONTRACT_PVT - show dependent code; OKC_INST_CND_PVT - show dependent code; OKC_OAT_PVT - show dependent code; OKC_OAT_PVT - show dependent code; OKC_OUTCOME_PVT - show dependent code; OKS_COPY_CONTRACT_PVT - show dependent code; OKS_COVERAGES_PVT - show dependent code