VIEW: APPS.OKX_CUST_SITES_V

Source

View Text - Preformatted

SELECT CA.CUST_ACCT_SITE_ID ID1, '#' ID2, CA.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, CA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CA.PARTY_SITE_ID PARTY_SITE_ID, PS.PARTY_ID PARTY_ID, PS.PARTY_SITE_NAME PARTY_SITE_NAME, CA.STATUS STATUS, L.LOCATION_ID LOCATION_ID, PS.PARTY_SITE_NAME NAME, L.COUNTRY COUNTRY, L.ADDRESS1 ADDRESS1, L.ADDRESS2 ADDRESS2, L.ADDRESS3 ADDRESS3, L.ADDRESS4 ADDRESS4, L.CITY CITY, L.POSTAL_CODE POSTAL_CODE, L.STATE STATE, L.PROVINCE PROVINCE, L.COUNTY COUNTY, L.DESCRIPTION LOCATION_DESCRIPTION, arp_addr_label_pkg.format_address(NULL,L.ADDRESS1,L.ADDRESS2, L.ADDRESS3,L.ADDRESS4,L.CITY,L.COUNTY,L.STATE,L.PROVINCE,L.POSTAL_CODE, NULL,L.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',300,1,1) DESCRIPTION, CA.ORG_ID ORG_ID, NULL PRIMARY_UOM_CODE, PS.ADDRESSEE ADDRESSEE FROM HZ_PARTY_SITES PS,HZ_LOCATIONS L,HZ_CUST_ACCT_SITES_ALL CA WHERE L.CONTENT_SOURCE_TYPE = 'USER_ENTERED' AND PS.LOCATION_ID = L.LOCATION_ID AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

View Text - HTML Formatted

SELECT CA.CUST_ACCT_SITE_ID ID1
, '#' ID2
, CA.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, CA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CA.PARTY_SITE_ID PARTY_SITE_ID
, PS.PARTY_ID PARTY_ID
, PS.PARTY_SITE_NAME PARTY_SITE_NAME
, CA.STATUS STATUS
, L.LOCATION_ID LOCATION_ID
, PS.PARTY_SITE_NAME NAME
, L.COUNTRY COUNTRY
, L.ADDRESS1 ADDRESS1
, L.ADDRESS2 ADDRESS2
, L.ADDRESS3 ADDRESS3
, L.ADDRESS4 ADDRESS4
, L.CITY CITY
, L.POSTAL_CODE POSTAL_CODE
, L.STATE STATE
, L.PROVINCE PROVINCE
, L.COUNTY COUNTY
, L.DESCRIPTION LOCATION_DESCRIPTION
, ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.COUNTY
, L.STATE
, L.PROVINCE
, L.POSTAL_CODE
, NULL
, L.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 300
, 1
, 1) DESCRIPTION
, CA.ORG_ID ORG_ID
, NULL PRIMARY_UOM_CODE
, PS.ADDRESSEE ADDRESSEE
FROM HZ_PARTY_SITES PS
, HZ_LOCATIONS L
, HZ_CUST_ACCT_SITES_ALL CA
WHERE L.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND PS.LOCATION_ID = L.LOCATION_ID
AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID