View: ECX_TP_HEADERS_V

Product:	ECX - XML Gateway
Description:	This table contains the trading partner header information
Implementation/DBA Data:	APPS.ECX_TP_HEADERS_V

View Text

SELECT ETPH.TP_HEADER_ID TP_HEADER_ID
, ELK.DESCRIPTION PARTY_TYPE
, ETPH.PARTY_ID PARTY_ID
, ETPH.PARTY_SITE_ID PARTY_SITE_ID
, HP.PARTY_NAME PARTY_NAME
, HZL.ADDRESS1 || ' ' || HZL.ADDRESS2 || ' '||HZL.CITY ||' ' || HZL.STATE || ' '|| HZL.POSTAL_CODE PARTY_SITE_NAME
, ETPH.COMPANY_ADMIN_EMAIL COMPANY_ADMIN_EMAIL
, ETPH.LAST_UPDATE_DATE
, ETPH.LAST_UPDATED_BY
, ETPH.CREATION_DATE
, ETPH.CREATED_BY
, ETPH.LAST_UPDATE_LOGIN
, HZC.ORG_ID ORG_ID
FROM HZ_PARTY_SITES HPS
, HZ_PARTIES HP
, HZ_LOCATIONS HZL
, HZ_CUST_ACCT_SITES HZC
, ECX_LOOKUP_VALUES ELK
, ECX_TP_HEADERS ETPH
WHERE HP.PARTY_ID = ETPH.PARTY_ID
AND HP.PARTY_ID = HPS.PARTY_ID
AND HPS.PARTY_SITE_ID = ETPH.PARTY_SITE_ID
AND HPS.PARTY_SITE_ID = HZC.PARTY_SITE_ID
AND HZL.LOCATION_ID = HPS.LOCATION_ID
AND ETPH.PARTY_TYPE = 'C'
AND ELK.LOOKUP_CODE = ETPH.PARTY_TYPE
AND ELK.LOOKUP_TYPE = 'PARTY_TYPE' UNION SELECT ETPH.TP_HEADER_ID TP_HEADER_ID
, ELK.DESCRIPTION PARTY_TYPE
, ETPH.PARTY_ID PARTY_ID
, ETPH.PARTY_SITE_ID PARTY_SITE_ID
, PV.VENDOR_NAME PARTY_NAME
, PVS.ADDRESS_LINE1 || ' '|| PVS.ADDRESS_LINE2|| ' '||PVS.CITY || ' ' ||PVS.STATE || ' '|| PVS.ZIP PARTY_SITE_NAME
, ETPH.COMPANY_ADMIN_EMAIL COMPANY_ADMIN_EMAIL
, ETPH.LAST_UPDATE_DATE
, ETPH.LAST_UPDATED_BY
, ETPH.CREATION_DATE
, ETPH.CREATED_BY
, ETPH.LAST_UPDATE_LOGIN
, PVS.ORG_ID ORG_ID
FROM PO_VENDORS PV
, PO_VENDOR_SITES PVS
, ECX_LOOKUP_VALUES ELK
, ECX_TP_HEADERS ETPH
WHERE PV.VENDOR_ID = ETPH.PARTY_ID
AND PV.VENDOR_ID = PVS.VENDOR_ID
AND PVS.VENDOR_SITE_ID = ETPH.PARTY_SITE_ID
AND ETPH.PARTY_TYPE = 'S'
AND ELK.LOOKUP_CODE = ETPH.PARTY_TYPE
AND ELK.LOOKUP_TYPE = 'PARTY_TYPE' UNION SELECT ETPH.TP_HEADER_ID TP_HEADER_ID
, ELK.DESCRIPTION PARTY_TYPE
, ETPH.PARTY_ID PARTY_ID
, ETPH.PARTY_SITE_ID PARTY_SITE_ID
, CBBV.BANK_BRANCH_NAME PARTY_NAME
, CBBV.ADDRESS_LINE1 || ' '||CBBV.ADDRESS_LINE2 || ' '|| CBBV.ADDRESS_LINE3||' '||CBBV.ADDRESS_LINE4||' '|| CBBV.CITY || ' ' || CBBV.STATE || ' '||CBBV.ZIP PARTY_SITE_NAME
, ETPH.COMPANY_ADMIN_EMAIL COMPANY_ADMIN_EMAIL
, ETPH.LAST_UPDATE_DATE
, ETPH.LAST_UPDATED_BY
, ETPH.CREATION_DATE
, ETPH.CREATED_BY
, ETPH.LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) ORG_ID
FROM CE_BANK_BRANCHES_V CBBV
, ECX_LOOKUP_VALUES ELK
, ECX_TP_HEADERS ETPH
WHERE CBBV.BRANCH_PARTY_ID = ETPH.PARTY_ID
AND ETPH.PARTY_TYPE = 'B'
AND ELK.LOOKUP_CODE = ETPH.PARTY_TYPE
AND ELK.LOOKUP_TYPE = 'PARTY_TYPE' UNION SELECT ETPH.TP_HEADER_ID TP_HEADER_ID
, ELK.DESCRIPTION PARTY_TYPE
, ETPH.PARTY_ID PARTY_ID
, ETPH.PARTY_SITE_ID PARTY_SITE_ID
, HRL.LOCATION_CODE PARTY_NAME
, HRL.ADDRESS_LINE_1 || ' '||HRL.ADDRESS_LINE_2 || HRL.ADDRESS_LINE_3 || ' '||HRL.TOWN_OR_CITY || ' ' || HRL.REGION_2 || ' '||HRL.POSTAL_CODE PARTY_SITE_NAME
, ETPH.COMPANY_ADMIN_EMAIL COMPANY_ADMIN_EMAIL
, ETPH.LAST_UPDATE_DATE
, ETPH.LAST_UPDATED_BY
, ETPH.CREATION_DATE
, ETPH.CREATED_BY
, ETPH.LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) ORG_ID
FROM HR_LOCATIONS HRL
, ECX_LOOKUP_VALUES ELK
, ECX_TP_HEADERS ETPH
WHERE HRL.LOCATION_ID = ETPH.PARTY_ID
AND ETPH.PARTY_TYPE = 'I'
AND ELK.LOOKUP_CODE = ETPH.PARTY_TYPE
AND ELK.LOOKUP_TYPE = 'PARTY_TYPE' UNION SELECT ETPH.TP_HEADER_ID TP_HEADER_ID
, ELK.DESCRIPTION PARTY_TYPE
, ETPH.PARTY_ID PARTY_ID
, ETPH.PARTY_SITE_ID PARTY_SITE_ID
, HP.PARTY_NAME PARTY_NAME
, HZL.ADDRESS1 || ' ' || HZL.ADDRESS2 || ' '||HZL.CITY ||' ' || HZL.STATE || ' '|| HZL.POSTAL_CODE PARTY_SITE_NAME
, ETPH.COMPANY_ADMIN_EMAIL COMPANY_ADMIN_EMAIL
, ETPH.LAST_UPDATE_DATE
, ETPH.LAST_UPDATED_BY
, ETPH.CREATION_DATE
, ETPH.CREATED_BY
, ETPH.LAST_UPDATE_LOGIN
, TO_NUMBER(NULL) ORG_ID
FROM HZ_PARTY_SITES HPS
, HZ_PARTIES HP
, HZ_LOCATIONS HZL
, ECX_LOOKUP_VALUES ELK
, ECX_TP_HEADERS ETPH
WHERE HP.PARTY_ID = ETPH.PARTY_ID
AND HP.PARTY_ID = HPS.PARTY_ID
AND HPS.PARTY_SITE_ID = ETPH.PARTY_SITE_ID
AND HZL.LOCATION_ID = HPS.LOCATION_ID
AND ETPH.PARTY_TYPE = 'CARRIER'
AND ELK.LOOKUP_CODE = ETPH.PARTY_TYPE
AND ELK.LOOKUP_TYPE = 'PARTY_TYPE'

Columns