VIEW: APPS.ECX_OAG_CONTROLAREA_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'