MSC_LOC_ASSOCIATIONS_TCA_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
SITE_ID LOCATION_ID SITE_TYPE

Query

SQL_Statement
SELECT HPS.PARTY_SITE_ID SITE_ID, HPS.LOCATION_ID, 2 SITE_TYPE FROM HZ_PARTY_SITES HPS WHERE EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.PARTY_ID = HPS.PARTY_ID)