VIEW: APPS.OKX_PARTY_SITES_V

Source

View Text - Preformatted

SELECT PSE.PARTY_SITE_ID ID1, '#' ID2, PSE.LOCATION_ID LOCATION_ID, PSE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER, PSE.PARTY_ID PARTY_ID, PSE.PARTY_SITE_NAME NAME, PSE.STATUS STATUS, LCN.COUNTRY COUNTRY, LCN.ADDRESS1 ADDRESS1, LCN.ADDRESS2 ADDRESS2, LCN.ADDRESS3 ADDRESS3, LCN.ADDRESS4 ADDRESS4, LCN.CITY CITY, LCN.POSTAL_CODE POSTAL_CODE, LCN.STATE STATE, LCN.PROVINCE PROVINCE, LCN.COUNTY COUNTY, LCN.DESCRIPTION LOCATION_DESCRIPTION, SUBSTR(replace(arp_addr_label_pkg.format_address(NULL,LCN.ADDRESS1,LCN.ADDRESS2,LCN.ADDRESS3,LCN.ADDRESS4,LCN.CITY,LCN.COUNTY,LCN.STATE,LCN.PROVINCE,LCN.POSTAL_CODE,NULL,LCN.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),CHR(10)),1,80) DESCRIPTION, PSE.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG , PSE.ADDRESSEE ADDRESSEE FROM HZ_PARTY_SITES PSE,HZ_LOCATIONS LCN WHERE LCN.LOCATION_ID = PSE.LOCATION_ID AND LCN.CONTENT_SOURCE_TYPE = 'USER_ENTERED'

View Text - HTML Formatted

SELECT PSE.PARTY_SITE_ID ID1
, '#' ID2
, PSE.LOCATION_ID LOCATION_ID
, PSE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, PSE.PARTY_ID PARTY_ID
, PSE.PARTY_SITE_NAME NAME
, PSE.STATUS STATUS
, LCN.COUNTRY COUNTRY
, LCN.ADDRESS1 ADDRESS1
, LCN.ADDRESS2 ADDRESS2
, LCN.ADDRESS3 ADDRESS3
, LCN.ADDRESS4 ADDRESS4
, LCN.CITY CITY
, LCN.POSTAL_CODE POSTAL_CODE
, LCN.STATE STATE
, LCN.PROVINCE PROVINCE
, LCN.COUNTY COUNTY
, LCN.DESCRIPTION LOCATION_DESCRIPTION
, SUBSTR(REPLACE(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, LCN.ADDRESS1
, LCN.ADDRESS2
, LCN.ADDRESS3
, LCN.ADDRESS4
, LCN.CITY
, LCN.COUNTY
, LCN.STATE
, LCN.PROVINCE
, LCN.POSTAL_CODE
, NULL
, LCN.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, CHR(10))
, 1
, 80) DESCRIPTION
, PSE.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG
, PSE.ADDRESSEE ADDRESSEE
FROM HZ_PARTY_SITES PSE
, HZ_LOCATIONS LCN
WHERE LCN.LOCATION_ID = PSE.LOCATION_ID
AND LCN.CONTENT_SOURCE_TYPE = 'USER_ENTERED'