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.CSC_CONDITION_HEADERS_V

Object Details

Object Name:	CSC_CONDITION_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_CONDITION_HEADERS_V
Subobject Name:
Status:	VALID

View Type

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

Defines a Condition to be evaluated upon the occurrence of an Action.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONDITION_HEADER_ID	NUMBER		Yes	Primary key column of OKC_CONDITION_HEADERS_B.
SFWT_FLAG	VARCHAR2	(3)	Yes	Indicates a value was changed in another language. Not fully implemented in 11i
ACTION_ID	NUMBER		Yes	Primary key column of OKC_ACTIONS_B
OBJECT_ID	NUMBER			Surrogate key used for primary unique identifiers.
DESCRIPTION	VARCHAR2	(1995)		User entered free format text description.
SHORT_DESCRIPTION	VARCHAR2	(600)		User entered free format text description.
COMMENTS	VARCHAR2	(1995)		User entered free format text comment.
ONE_TIME_YN	VARCHAR2	(3)	Yes	Yes/No field.
CONDITION_NAME	VARCHAR2	(150)	Yes	Condition name.
CONDITION_VALID_YN	VARCHAR2	(3)	Yes	Yes/No field.
BEFORE_AFTER	VARCHAR2	(3)		Before/After field.
TEMPLATE_YN	VARCHAR2	(3)	Yes	Yes/No field to denote if a template was used.
DATE_ACTIVE	DATE		Yes	Date condition became active.
DATE_INACTIVE	DATE			Date condition became inactive.
CONDITION_HEADER_TYPE	VARCHAR2	(30)	Yes	Condition type
ACTION_NAME	VARCHAR2	(150)	Yes	Action name.
ACTION_DESCRIPTION	VARCHAR2	(1995)		User entered free format text description for an Action.
ACTION_TYPE	VARCHAR2	(30)	Yes	Action type
COUNTER_ACTION_YN	VARCHAR2	(3)	Yes	Yes/No field.
ACTION_ENABLED	VARCHAR2	(3)	Yes	Yes/No field.

Query Text

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


SELECT CONDITION_HEADER_ID
,      SFWT_FLAG
,      ACTION_ID
,      OBJECT_ID
,      DESCRIPTION
,      SHORT_DESCRIPTION
,      COMMENTS
,      ONE_TIME_YN
,      CONDITION_NAME
,      CONDITION_VALID_YN
,      BEFORE_AFTER
,      TEMPLATE_YN
,      DATE_ACTIVE
,      DATE_INACTIVE
,      CONDITION_HEADER_TYPE
,      ACTION_NAME
,      ACTION_DESCRIPTION
,      ACTION_TYPE
,      COUNTER_ACTION_YN
,      ACTION_ENABLED
FROM APPS.CSC_CONDITION_HEADERS_V;

Dependencies

[top of page]

APPS.CSC_CONDITION_HEADERS_V references the following:

APPS: OKC_ACTIONS_V; OKC_CONDITION_HEADERS_V

APPS.CSC_CONDITION_HEADERS_V is not referenced by any database object