View: ECX_OAG_CONTROLAREA_TP_V

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

View Text

SELECT EEP.EXT_SUBTYPE VERB_VALUE
, EEP.EXT_SUBTYPE VERB_ATTVALUE
, EEP.EXT_TYPE NOUN_VALUE
, EEP.EXT_TYPE NOUN_ATTVALUE
, ET.TRANSACTION_TYPE COMPONENT
, ET.TRANSACTION_SUBTYPE TASK
, ECX_TRADING_PARTNER_PVT.GETOAGLOGICALID LOGICAL_ID
, ECX_STANDARD.GETREFERENCEID REFERENCE_ID
, USER AUTHID
, SYSDATE DATETIME
, 'CREATION' DATE_ATTVALUE
, USERENV('LANG') LANGUAGE
, ETD.CONFIRMATION CONFIRMATION
, NULL REVISION_VALUE
, NULL REVISION_ATTVALUE
, VNLS.VALUE CODEPAGE
, ET.TRANSACTION_TYPE TRANSACTION_TYPE
, ET.TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE
, ETD.USERNAME USERNAME
, ETD.SOURCE_TP_LOCATION_CODE SOURCE_TP_LOCATION_CODE
, ETH.PARTY_ID PARTY_ID
, ETH.PARTY_SITE_ID PARTY_SITE_ID
, ETH.PARTY_TYPE PARTY_TYPE
FROM ECX_STANDARDS_B ES
, ECX_TRANSACTIONS_B ET
, ECX_EXT_PROCESSES EEP
, V$NLS_PARAMETERS VNLS
, ECX_TP_HEADERS ETH
, ECX_TP_DETAILS ETD 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' AND ETH.PARTY_TYPE = ET.PARTY_TYPE AND ETD.TP_HEADER_ID = ETH.TP_HEADER_ID AND ETD.EXT_PROCESS_ID = EEP.EXT_PROCESS_ID

Columns