VIEW: APPS.ECX_TP_DETAILS_V

Source

View Text - Preformatted

SELECT tpd.tp_header_id, tpd.tp_detail_id, tpd.map_id, tpd.ext_process_id, et.transaction_type, et.transaction_subtype, es.standard_code, ep.ext_type, ep.ext_subtype, ep.direction, tpd.connection_type, tpd.hub_user_id, decode(tpd.connection_type, 'DIRECT', tpd.protocol_type, eh.protocol_type) protocol_type, decode(tpd.connection_type, 'DIRECT',tpd.protocol_address,eh.protocol_address) protocol_address, decode(tpd.hub_user_id, NULL, tpd.username,ehu.username) username, decode(tpd.hub_user_id, NULL, tpd.password, ehu.password) password, tpd.routing_id, tpd.confirmation, decode(tpd.hub_user_id, NULL, tpd.source_tp_location_code, ehu.hub_entity_code) source_tp_location_code, tpd.external_tp_location_code, tpd.omb_sync, tpd.created_by, tpd.creation_date, tpd.last_updated_by, tpd.last_update_date, tpd.last_update_login, tpd.hub_id from ecx_tp_details tpd, ecx_ext_processes ep,ecx_transactions_b et, ecx_standards_b es, ecx_hub_users ehu, ecx_hubs eh where tpd.ext_process_id = ep.ext_process_id and et.transaction_id = ep.transaction_id and es.standard_id = ep.standard_id and nvl(tpd.hub_user_id ,0) = ehu.hub_user_id(+) and nvl(tpd.hub_id, 0) = eh.hub_id (+)

View Text - HTML Formatted

SELECT TPD.TP_HEADER_ID
, TPD.TP_DETAIL_ID
, TPD.MAP_ID
, TPD.EXT_PROCESS_ID
, ET.TRANSACTION_TYPE
, ET.TRANSACTION_SUBTYPE
, ES.STANDARD_CODE
, EP.EXT_TYPE
, EP.EXT_SUBTYPE
, EP.DIRECTION
, TPD.CONNECTION_TYPE
, TPD.HUB_USER_ID
, DECODE(TPD.CONNECTION_TYPE
, 'DIRECT'
, TPD.PROTOCOL_TYPE
, EH.PROTOCOL_TYPE) PROTOCOL_TYPE
, DECODE(TPD.CONNECTION_TYPE
, 'DIRECT'
, TPD.PROTOCOL_ADDRESS
, EH.PROTOCOL_ADDRESS) PROTOCOL_ADDRESS
, DECODE(TPD.HUB_USER_ID
, NULL
, TPD.USERNAME
, EHU.USERNAME) USERNAME
, DECODE(TPD.HUB_USER_ID
, NULL
, TPD.PASSWORD
, EHU.PASSWORD) PASSWORD
, TPD.ROUTING_ID
, TPD.CONFIRMATION
, DECODE(TPD.HUB_USER_ID
, NULL
, TPD.SOURCE_TP_LOCATION_CODE
, EHU.HUB_ENTITY_CODE) SOURCE_TP_LOCATION_CODE
, TPD.EXTERNAL_TP_LOCATION_CODE
, TPD.OMB_SYNC
, TPD.CREATED_BY
, TPD.CREATION_DATE
, TPD.LAST_UPDATED_BY
, TPD.LAST_UPDATE_DATE
, TPD.LAST_UPDATE_LOGIN
, TPD.HUB_ID
FROM ECX_TP_DETAILS TPD
, ECX_EXT_PROCESSES EP
, ECX_TRANSACTIONS_B ET
, ECX_STANDARDS_B ES
, ECX_HUB_USERS EHU
, ECX_HUBS EH
WHERE TPD.EXT_PROCESS_ID = EP.EXT_PROCESS_ID
AND ET.TRANSACTION_ID = EP.TRANSACTION_ID
AND ES.STANDARD_ID = EP.STANDARD_ID
AND NVL(TPD.HUB_USER_ID
, 0) = EHU.HUB_USER_ID(+)
AND NVL(TPD.HUB_ID
, 0) = EH.HUB_ID (+)