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


VIEW: APPS.OKL_CS_IH_ACTIVITIES_UV

Object Details
Object Name: OKL_CS_IH_ACTIVITIES_UV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_IH_ACTIVITIES_UV
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_ID NUMBER

PARTY_ID NUMBER
Yes
INTERACTION_ID NUMBER (15) Yes
ACTION_ITEM_ID NUMBER (15) Yes
ACTION_ITEM_DESC VARCHAR2 (240) Yes
OUTCOME_CODE VARCHAR2 (80)
OUTCOME_DESC VARCHAR2 (240)
OUTCOME_MEANING VARCHAR2 (240) Yes
RESULT_CODE VARCHAR2 (80)
RESULT_DESCRIPTION VARCHAR2 (240)
REASON_CODE VARCHAR2 (80)
REASON_DESC VARCHAR2 (240)
RESOURCE_NAME VARCHAR2 (360)
DURATION NUMBER

START_DATE DATE

Start Date
END_DATE DATE

End Date
FOLLOWUP_ACTION VARCHAR2 (80)
DOC_SOURCE VARCHAR2 (80)
Query Text

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


SELECT CONTRACT_ID
,      PARTY_ID
,      INTERACTION_ID
,      ACTION_ITEM_ID
,      ACTION_ITEM_DESC
,      OUTCOME_CODE
,      OUTCOME_DESC
,      OUTCOME_MEANING
,      RESULT_CODE
,      RESULT_DESCRIPTION
,      REASON_CODE
,      REASON_DESC
,      RESOURCE_NAME
,      DURATION
,      START_DATE
,      END_DATE
,      FOLLOWUP_ACTION
,      DOC_SOURCE
FROM APPS.OKL_CS_IH_ACTIVITIES_UV;

Dependencies

[top of page]

APPS.OKL_CS_IH_ACTIVITIES_UV references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewJTF_IH_ACTION_ITEMS_VL
ViewJTF_IH_ACTIVITIES_VL
ViewJTF_IH_INTERACTIONS_V
ViewJTF_IH_OUTCOMES_VL
ViewOKL_CS_INTERACTIONS_PARTY_UV

APPS.OKL_CS_IH_ACTIVITIES_UV is not referenced by any database object