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.

[Home] [Help]

View: ECX_OAG_CONTROLAREA_V

Product:	ECX - XML Gateway
Description:	View for the Open Applications Group (OAG) Control Area.
Implementation/DBA Data:	APPS.ECX_OAG_CONTROLAREA_V

View Text

SELECT EEP.EXT_SUBTYPE VERB_VALUE
, EEP.EXT_SUBTYPE VERB_ATTVALUE
, EEP.EXT_TYPE NOUN_VALUE
, EEP.EXT_TYPE NOUN_ATTVALUE
, EEP.EXT_TYPE COMPONENT
, EEP.EXT_SUBTYPE TASK
, FND_PROFILE.VALUE('ECX_OAG_LOGICALID') LOGICAL_ID
, '1' REFERENCE_ID
, USER AUTHID
, SYSDATE DATETIME
, 'CREATION' DATE_ATTVALUE
, USERENV('LANG') LANGUAGE
, 0 CONFIRMATION
, NULL REVISION_VALUE
, NULL REVISION_ATTVALUE
, VNLS.VALUE CODEPAGE
, ET.TRANSACTION_TYPE TRANSACTION_TYPE
, ET.TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE
FROM ECX_STANDARDS_B ES
, ECX_TRANSACTIONS_B ET
, ECX_EXT_PROCESSES EEP
, V$NLS_PARAMETERS VNLS
WHERE ES.STANDARD_CODE = 'OAG' AND ES.STANDARD_ID = EEP.STANDARD_ID AND EEP.TRANSACTION_ID = ET.TRANSACTION_ID AND EEP.DIRECTION = 'OUT' AND VNLS.PARAMETER (+) = 'NLS_CHARACTERSET'

Columns

Name
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