[Home] [Help] [Dependency Information]
Object Name: | OKC_LAUNCH_COMMGRID_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_LAUNCH_COMMGRID_V |
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 |
---|---|---|---|---|
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. |
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;
|
|
|