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

VIEW: APPS.OKC_CONDITION_HEADERS_V

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

View Type

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


The definition of an event of interest
ie. a standard event, PUBLISHED_EVENT, satisfying the criteria specified by the EVENT_DEF_LINES
most usually it would be defined for a generic TIMEVALUE associated with a RULE of subtype "schedule "
However functionality may be provided to allow stand alone EVENT_DEF
The ocurrence of an EVENT_DEF would immediately trigger any associated OUTCOME
and would schedule according to the TIMEVALUE any RULE associated OUTCOME


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
ID NUMBER
Yes System generated Unique Identifier. Also primary key of the base table OKC_CONDITION_HEADERS_B.
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.
SFWT_FLAG VARCHAR2 (3) Yes Indicates a value was changed in another language. Not fully implemented in 11i
ACN_ID NUMBER
Yes Unique identifier of action. Refers to ID in OKC_ACTIONS_B.
COUNTER_GROUP_ID NUMBER (15)
Unique identifier of counter group. Refers to COUNTER_GROUP_ ID in CS_COUNTER_GROUPS.
DESCRIPTION VARCHAR2 (1995)
Condition description.
SHORT_DESCRIPTION VARCHAR2 (600)
Short description for the Condition
COMMENTS VARCHAR2 (1995)
User entered comment.
ONE_TIME_YN VARCHAR2 (3) Yes Indicates that the condition should be evaluated only once. Valid values Y or N.
NAME VARCHAR2 (150) Yes Name of the Condition
CONDITION_VALID_YN VARCHAR2 (3) Yes Indicates that the condition lines are syntactically valid for a SQL statement. Valid values Y or N.
BEFORE_AFTER VARCHAR2 (3)
Used for Date Based Conditions to evaluate the offset in days before or after a date based action e.g. 10 days before Contract Terminated. Valid values A or B.
TRACKED_YN VARCHAR2 (3) Yes Indicates whether the condition is tracked. If Yes, It will generate tasks to the owner identified by TASK_OWNER_ID. Valid values Y or N.
CNH_VARIANCE NUMBER (4)
Offset in days (used with before/after)
DNZ_CHR_ID NUMBER

Contract ID. Denormalized for performance.
TEMPLATE_YN VARCHAR2 (3) Yes Indicates whether the condition is a template. Valid values Y or N.
DATE_ACTIVE DATE
Yes Date condition became active.
OBJECT_ID NUMBER

Stores the unique identifier of the object stored in JTOT_OBJECT_CODE. Refers to the SELECT_ID in JTF_OBJECTS_B.
DATE_INACTIVE DATE

Date condition became inactive.
JTOT_OBJECT_CODE VARCHAR2 (30)
Indicates the source to which the condition is attached. For example OKC_K_HEADERS for Headers, OKC_K_LINES for Lines. Similarly it can be referenced by Customer Support , Service Counters etc. Refers to OBJECT_CODE in JTF_OBJECTS_B.
TASK_OWNER_ID NUMBER

Task owner for the condition. Refers to RESOURCE_ID of JTF_RS_RESOURCE_EXTNS.
LAST_RUNDATE DATE

Date on which �Date Assembler� concurrent request ran successfully for this condition. Relevant for Conditions based on date based actions.
CNH_TYPE VARCHAR2 (30) Yes Type of Condition. Valid values are ABC (Action Based Condition) and DBC (date based condition).
APPLICATION_ID NUMBER

Application Identifier
SEEDED_FLAG VARCHAR2 (3)
Indicates whether a record is seeded data
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column.
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column.
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
,      SFWT_FLAG
,      ACN_ID
,      COUNTER_GROUP_ID
,      DESCRIPTION
,      SHORT_DESCRIPTION
,      COMMENTS
,      ONE_TIME_YN
,      NAME
,      CONDITION_VALID_YN
,      BEFORE_AFTER
,      TRACKED_YN
,      CNH_VARIANCE
,      DNZ_CHR_ID
,      TEMPLATE_YN
,      DATE_ACTIVE
,      OBJECT_ID
,      DATE_INACTIVE
,      JTOT_OBJECT_CODE
,      TASK_OWNER_ID
,      LAST_RUNDATE
,      CNH_TYPE
,      APPLICATION_ID
,      SEEDED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_CONDITION_HEADERS_V;

Dependencies

[top of page]

APPS.OKC_CONDITION_HEADERS_V references the following:

SchemaAPPS
SynonymOKC_CONDITION_HEADERS_B
SynonymOKC_CONDITION_HEADERS_TL
APPS.OKC_CONDITION_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyCSC_ACTION_ASSEMBLER_PVT - show dependent code
ViewCSC_CONDITION_HEADERS_V
ViewCSC_PLAN_LINES_V
PL/SQL PackageOKC_CNH_PVT - show dependent code
Package BodyOKC_CNH_PVT - show dependent code
Package BodyOKC_CNL_PVT - show dependent code
Package BodyOKC_COE_PVT - show dependent code
Package BodyOKC_CONDITION_EVAL_PVT - show dependent code
Package BodyOKC_COPY_CONTRACT_PVT - show dependent code
Package BodyOKC_DATE_ASSEMBLER_PUB - show dependent code
Package BodyOKC_DELETE_CONTRACT_PVT - show dependent code
Package BodyOKC_INST_CND_PVT - show dependent code
Package BodyOKC_OCE_PVT - show dependent code
Package BodyOKC_PROCESS_PVT - show dependent code
Package BodyOKC_QUERY - show dependent code
Package BodyOKS_COPY_CONTRACT_PVT - show dependent code
Package BodyOKS_COVERAGES_PVT - show dependent code
Package BodyOKS_CT_EVENTS_WFA - show dependent code
Package BodyOKS_RENCPY_PVT - show dependent code