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


VIEW: APPS.IEM_INBEMAIL_COUNTS_V

Object Details
Object Name: IEM_INBEMAIL_COUNTS_V
Object Type: VIEW
Owner: APPS
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
IEU_OBJECT_FUNCTION CHAR (1)
UWQ Object Function
IEU_OBJECT_PARAMETERS CHAR (1)
UWQ Object Parameter
IEU_MEDIA_TYPE_UUID CHAR (32)
UWQ Media Type UUID
IEU_PARAM_PK_COL CHAR (22)
Primary Key Column name
IEU_PARAM_PK_VALUE VARCHAR2 (40)
Primary Key Column value
RESOURCE_TYPE CHAR (13)
Resource Type
EMAIL_ACCOUNT_ID NUMBER (15)
Master email account id
NAME VARCHAR2 (30) Yes Name
RESOURCE_ID NUMBER (15) Yes Resource Id
TOTAL NUMBER

Total
EMAIL_USER VARCHAR2 (256)
Email User
WAITTIME VARCHAR2 (122)
Waittime
IEU_ACTION_OBJECT_CODE CHAR (32)
UWQ Action Object code
Query Text

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


SELECT IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      RESOURCE_TYPE
,      EMAIL_ACCOUNT_ID
,      NAME
,      RESOURCE_ID
,      TOTAL
,      EMAIL_USER
,      WAITTIME
,      IEU_ACTION_OBJECT_CODE
FROM APPS.IEM_INBEMAIL_COUNTS_V;

Dependencies

[top of page]

APPS.IEM_INBEMAIL_COUNTS_V references the following:

SchemaAPPS
SynonymIEM_ACCOUNT_ROUTE_CLASS
SynonymIEM_AGENTS
SynonymIEM_MSTEMAIL_ACCOUNTS
SynonymIEM_REROUTE_HISTS
SynonymIEM_ROUTE_CLASSIFICATIONS
SynonymIEM_RT_PROC_EMAILS
ViewJTF_RS_GROUP_MEMBERS_VL

APPS.IEM_INBEMAIL_COUNTS_V is not referenced by any database object