View: EGO_PARTY_SITE_GLN_V

Product:	EGO - Advanced Product Catalog
Description:	This view contains Customers and their GLNs.
Implementation/DBA Data:	APPS.EGO_PARTY_SITE_GLN_V

View Text

SELECT CS.CUST_ACCT_SITE_ID ADDRESS_ID
, CS.PARTY_SITE_ID PARTY_SITE_ID
, PS.GLOBAL_LOCATION_NUMBER GLN
, P.PARTY_NAME PARTY_NAME
, HZ_FORMAT_PUB.FORMAT_ADDRESS(L.LOCATION_ID
, ''
, ''
, '
, '
, ''
, ''
, ''
, '') ADDRESS
FROM HZ_PARTY_SITES PS
, HZ_PARTIES P
, HZ_LOCATIONS L
, HZ_CUST_ACCT_SITES_ALL CS
WHERE CS.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND P.PARTY_ID = PS.PARTY_ID
AND PS.LOCATION_ID = L.LOCATION_ID
AND P.PARTY_TYPE = 'ORGANIZATION'
AND PS.GLOBAL_LOCATION_NUMBER IS NOT NULL

Columns