VIEW: APPS.OKE_CUST_SITE_USES_V

Source

View Text - Preformatted

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 , 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

View Text - HTML Formatted

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
, 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