Product: | OZF - Trade Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OZF_X_CUST_SITE_USES |
SELECT CS.SITE_USE_ID
, CA.CUST_ACCOUNT_ID
, CA.CUST_ACCT_SITE_ID
, PS.PARTY_ID
, CA.PARTY_SITE_ID
, PS.PARTY_SITE_NAME
, CS.SITE_USE_CODE
, 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
, CS.ORG_ID
FROM HZ_LOCATIONS L
, HZ_PARTY_SITES PS
, HZ_CUST_SITE_USES CS
, HZ_CUST_ACCT_SITES CA
WHERE CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND PS.LOCATION_ID = L.LOCATION_ID