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

VIEW: APPS.OKC_LAUNCH_COMMGRID_V

Object Details
Object Name: OKC_LAUNCH_COMMGRID_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_LAUNCH_COMMGRID_V
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
INTERACTION_ID NUMBER (15)
Unique Identifier of the Interaction from JTF_IH_INTERACTIONS
CONTRACT_ID NUMBER

Unique Identifier of the Contract
ROLE VARCHAR2 (30)
The Description for the Party Role for the contract.
PARTY_NAME VARCHAR2 (360)
The Name of the Party involved in the interaction
PARTY_ID NUMBER

The ID of the Party involved in the interaction.(Could be a Resource ID or Party Id)
AGENT_NAME VARCHAR2 (360)
The Resource Name belonging to the Agent involved in the interaction.
AGENT_ID NUMBER

The Resource ID belonging to the Agent involved in the interaction.
TOUCHPOINT1_TYPE VARCHAR2 (30)
This indicates the category of the Resource defined under Party Id.
TOUCHPOINT2_TYPE VARCHAR2 (30)
This indicates the category of the Resource defined under Agent Id (usually an employee).
MEDIA_TYPE VARCHAR2 (80)
Indicates the type of seeded media involved in the Communication. (e.g. Phone, Email, FAX etc.) from JTF_IH_MEDIA_ITEMS.
MEDIA_MEANING VARCHAR2 (80)
Description for the type of media involved in the Communication. (e.g. Phone, Email, FAX etc.) from FND_LOOKUPS.
CUST_ACCOUNT_ID NUMBER

Customer Account Id from JTF_IH_ACTIVITIES
ACT_START_DATE DATE

Starting time for the Activity from JTF_IH_ACTIVITIES
ACT_END_DATE DATE

Ending time for the Activity from JTF_IH_ACTIVITIES
INT_START_DATE DATE

Starting time for the Interaction.
INT_END_DATE DATE

Ending time for the Interaction .
DESCRIPTION VARCHAR2 (1000)
User entered free format text description
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
ACTION_ITEM_ID NUMBER (15)
Id for the seeded Action Item from JTF_IH_ACTION_ITEMS .
ACTION_ITEM_MEANING VARCHAR2 (240)
Description for the seeded Action Item from FND_LOOKUPS (e.g. Service Request, Customer Lead, Quote, etc.)
OUTCOME_ID NUMBER (15)
Id for the seeded Outcome from JTF_IH_OUTCOMES.
OUTCOME_MEANING VARCHAR2 (240)
Description for the seeded Outcome from FND_LOOKUPS (e.g. Customer complaint, No Answer, etc.)
NOTES_HEADER VARCHAR2 (2000)
Brief Subject about the Interaction.
NOTES_DETAIL CLOB (4000)
Detailed description of the Interaction as recorded in a Free-format text.
Query Text

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


SELECT INTERACTION_ID
,      CONTRACT_ID
,      ROLE
,      PARTY_NAME
,      PARTY_ID
,      AGENT_NAME
,      AGENT_ID
,      TOUCHPOINT1_TYPE
,      TOUCHPOINT2_TYPE
,      MEDIA_TYPE
,      MEDIA_MEANING
,      CUST_ACCOUNT_ID
,      ACT_START_DATE
,      ACT_END_DATE
,      INT_START_DATE
,      INT_END_DATE
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ACTION_ITEM_ID
,      ACTION_ITEM_MEANING
,      OUTCOME_ID
,      OUTCOME_MEANING
,      NOTES_HEADER
,      NOTES_DETAIL
FROM APPS.OKC_LAUNCH_COMMGRID_V;

Dependencies

[top of page]

APPS.OKC_LAUNCH_COMMGRID_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_PARTIES
PL/SQL PackageJTF_COMMON_PVT - show dependent code
ViewJTF_IH_ACTION_ITEMS_VL
SynonymJTF_IH_ACTIVITIES
SynonymJTF_IH_INTERACTIONS
SynonymJTF_IH_MEDIA_ITEMS
ViewJTF_IH_OUTCOMES_VL
PL/SQL PackageJTF_NOTES_PKG - show dependent code
ViewJTF_NOTES_VL
ViewJTF_OBJECTS_VL
ViewJTF_RS_RESOURCE_EXTNS_VL
APPS.OKC_LAUNCH_COMMGRID_V is referenced by following:

SchemaAPPS
Package BodyOKS_OKSSUMRP_XMLP_PKG - show dependent code