View: OKX_PARTY_SITE_USES_V

Product:	OKX - Contracts Integration
Description:	Party site uses
Implementation/DBA Data:	APPS.OKX_PARTY_SITE_USES_V

View Text

SELECT SU.PARTY_SITE_USE_ID ID1
, '#' ID2
, PS.PARTY_SITE_ID PARTY_SITE_ID
, PS.LOCATION_ID LOCATION_ID
, PS.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, PS.PARTY_ID PARTY_ID
, PS.PARTY_SITE_NAME NAME
, SU.COMMENTS COMMENTS
, SU.STATUS STATUS
, 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
, SUBSTR(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'
, 80
, 1
, 1)
, 1
, 80) DESCRIPTION
, SU.SITE_USE_TYPE SITE_USE_TYPE
, NULL PRIMARY_UOM_CODE
FROM HZ_PARTY_SITE_USES SU
, HZ_PARTY_SITES PS
, HZ_LOCATIONS L
WHERE L.LOCATION_ID = PS.LOCATION_ID
AND L.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND SU.PARTY_SITE_ID (+) = PS.PARTY_SITE_ID

Columns