Product: | ECX - XML Gateway |
---|---|
Description: | This view contains the trading partner detail information. |
Implementation/DBA Data: | APPS.ECX_TP_DETAILS_V |
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 (+)