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

VIEW: APPS.JTF_EC_ESC_CONTACTS_REF_DOCS

Object Details
Object Name: JTF_EC_ESC_CONTACTS_REF_DOCS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_EC_ESC_CONTACTS_REF_DOCS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Yes
TASK_NUMBER VARCHAR2 (30) Yes
CUSTOMER_ID NUMBER

PARTY_NAME VARCHAR2 (360)
CUST_ACCOUNT_ID NUMBER

ADDRESS_ID NUMBER

CITY VARCHAR2 (60)
TASK_STATUS_ID NUMBER
Yes
OWNER_ID NUMBER
Yes
ACTUAL_START_DATE DATE

OWNER_TERRITORY_ID NUMBER

DESCRIPTION VARCHAR2 (4000)
REASON_CODE VARCHAR2 (30)
CONTACT_TYPE_CODE VARCHAR2 (30)
CONTACT_ID NUMBER

OBJECT_TYPE_CODE VARCHAR2 (30)
OBJECT_ID NUMBER

OBJECT_NUMBER VARCHAR2 (80)
Query Text

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


SELECT TASK_ID
,      TASK_NUMBER
,      CUSTOMER_ID
,      PARTY_NAME
,      CUST_ACCOUNT_ID
,      ADDRESS_ID
,      CITY
,      TASK_STATUS_ID
,      OWNER_ID
,      ACTUAL_START_DATE
,      OWNER_TERRITORY_ID
,      DESCRIPTION
,      REASON_CODE
,      CONTACT_TYPE_CODE
,      CONTACT_ID
,      OBJECT_TYPE_CODE
,      OBJECT_ID
,      OBJECT_NUMBER
FROM APPS.JTF_EC_ESC_CONTACTS_REF_DOCS;

Dependencies

[top of page]

APPS.JTF_EC_ESC_CONTACTS_REF_DOCS references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewJTF_ESCALATION_TASK_V
SynonymJTF_TASK_CONTACTS
ViewJTF_TASK_REFERENCES_VL

APPS.JTF_EC_ESC_CONTACTS_REF_DOCS is not referenced by any database object