VIEW: APPS.ECX_OAG_CONTROLAREA_TP_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, 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

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
, 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