eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ECX_OAG_CONTROLAREA_TP_V

Object Details

Object Name:	ECX_OAG_CONTROLAREA_TP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ECX.ECX_OAG_CONTROLAREA_TP_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	(100)	Yes	Component
TASK	VARCHAR2	(100)	Yes	Task
LOGICAL_ID	VARCHAR2	(4000)		Logical Identifier
REFERENCE_ID	VARCHAR2	(4000)		Reference Identifier
AUTHID	VARCHAR2	(30)		Authorization Identifier
DATETIME	DATE			Datetime
DATE_ATTVALUE	CHAR	(8)		Datetime Attribute Value
LANGUAGE	VARCHAR2	(52)		Language
CONFIRMATION	NUMBER	(2)		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
USERNAME	VARCHAR2	(512)		username
SOURCE_TP_LOCATION_CODE	VARCHAR2	(200)		Source trading partner location code
PARTY_ID	NUMBER		Yes	Party Identifier
PARTY_SITE_ID	NUMBER		Yes	Party Site Identifier
PARTY_TYPE	VARCHAR2	(30)	Yes	Party Type

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
,      USERNAME
,      SOURCE_TP_LOCATION_CODE
,      PARTY_ID
,      PARTY_SITE_ID
,      PARTY_TYPE
FROM APPS.ECX_OAG_CONTROLAREA_TP_V;

Dependencies

[top of page]

APPS.ECX_OAG_CONTROLAREA_TP_V references the following:

APPS: ECX_EXT_PROCESSES; ECX_STANDARD - show dependent code; ECX_STANDARDS_B; ECX_TP_DETAILS; ECX_TP_HEADERS; ECX_TRADING_PARTNER_PVT - show dependent code; ECX_TRANSACTIONS_B
PUBLIC: V$NLS_PARAMETERS

APPS.ECX_OAG_CONTROLAREA_TP_V is referenced by following:

APPS: XNB_CMN_PVT - show dependent code; XNB_ITEM_BATCH_PVT - show dependent code