[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CS_IH_ACTIVITIES_UV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | OKL.OKL_CS_IH_ACTIVITIES_UV
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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) |
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;
APPS
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
JTF_IH_ACTION_ITEMS_VL
JTF_IH_ACTIVITIES_VL
JTF_IH_INTERACTIONS_V
JTF_IH_OUTCOMES_VL
OKL_CS_INTERACTIONS_PARTY_UV
APPS.OKL_CS_IH_ACTIVITIES_UV is not referenced by any database object
|
|
|
|