View: OKE_CUST_SITE_USES_V

Product:	OKE - Project Contracts
Description:	Customer sites and usage information
Implementation/DBA Data:	APPS.OKE_CUST_SITE_USES_V

View Text

SELECT CS.SITE_USE_ID
, '#'
, CS.SITE_USE_ID
, NVL(CS.LOCATION
, '*') || ' (' || TO_CHAR(CA.CUST_ACCT_SITE_ID) || ')'
, CA.CUST_ACCT_SITE_ID
, CA.CUST_ACCOUNT_ID
, CA.PARTY_SITE_ID
, PS.PARTY_ID
, PT.NAME
, PS.PARTY_SITE_NAME
, CS.SITE_USE_CODE
, DECODE( CS.STATUS
, 'A'
, 'A'
, 'I'
, 'I'
, 'I' )
, CS.STATUS
, L.LOCATION_ID
, CS.LOCATION
, L.COUNTRY
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.POSTAL_CODE
, L.STATE
, L.PROVINCE
, L.COUNTY
, L.DESCRIPTION
, PS.START_DATE_ACTIVE
, PS.END_DATE_ACTIVE
, 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 )
, CS.ORG_ID
, NULL
FROM HZ_PARTY_SITES PS
, HZ_LOCATIONS L
, HZ_CUST_ACCT_SITES_ALL CA
, HZ_CUST_SITE_USES_ALL CS
, OKX_PARTIES_V PT
WHERE PS.LOCATION_ID = L.LOCATION_ID
AND L.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
AND PT.ID1 = PS.PARTY_ID

Columns