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

VIEW: APPS.ECX_OAG_CONTROLAREA_V

Object Details
Object Name: ECX_OAG_CONTROLAREA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewECX.ECX_OAG_CONTROLAREA_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View for the Open Applications Group (OAG) Control Area.


[View Source]

Columns
Name Datatype Length Mandatory Comments
VERB_VALUE VARCHAR2 (80) Yes Verb Value
VERB_ATTVALUE VARCHAR2 (80) Yes Verb Attribute Value
NOUN_VALUE VARCHAR2 (80) Yes Noun Value
NOUN_ATTVALUE VARCHAR2 (80) Yes Noun Attribute Value
COMPONENT VARCHAR2 (80) Yes Component
TASK VARCHAR2 (80) Yes Task
LOGICAL_ID VARCHAR2 (4000)
Logical Identifier
REFERENCE_ID CHAR (1)
Reference Identifier
AUTHID VARCHAR2 (30)
Authorization Identifier
DATETIME DATE

Datetime
DATE_ATTVALUE CHAR (8)
Datetime Attribute Value
LANGUAGE VARCHAR2 (52)
Language
CONFIRMATION NUMBER

Confirmation Code
REVISION_VALUE VARCHAR2 (0)
Revision Value
REVISION_ATTVALUE VARCHAR2 (0)
Revision Attribute Value
CODEPAGE VARCHAR2 (64)
Code Page
TRANSACTION_TYPE VARCHAR2 (100) Yes Internal Transaction Type
TRANSACTION_SUBTYPE VARCHAR2 (100) Yes Internal Transaction Subtype
Query Text

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


SELECT VERB_VALUE
,      VERB_ATTVALUE
,      NOUN_VALUE
,      NOUN_ATTVALUE
,      COMPONENT
,      TASK
,      LOGICAL_ID
,      REFERENCE_ID
,      AUTHID
,      DATETIME
,      DATE_ATTVALUE
,      LANGUAGE
,      CONFIRMATION
,      REVISION_VALUE
,      REVISION_ATTVALUE
,      CODEPAGE
,      TRANSACTION_TYPE
,      TRANSACTION_SUBTYPE
FROM APPS.ECX_OAG_CONTROLAREA_V;

Dependencies

[top of page]

APPS.ECX_OAG_CONTROLAREA_V references the following:

SchemaAPPS
SynonymECX_EXT_PROCESSES
SynonymECX_STANDARDS_B
SynonymECX_TRANSACTIONS_B
PL/SQL PackageFND_PROFILE - show dependent code
SchemaPUBLIC
SynonymV$NLS_PARAMETERS

APPS.ECX_OAG_CONTROLAREA_V is not referenced by any database object