MSC_CUSTOMER_SITES_TCA_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PARTNER_SITE_ID PARTNER_ID TP_SITE_CODE LOCATION_ID PARTNER_TYPE LAST_UPDATE_DATE TIMEZONE_CODE

Query

SQL_Statement
SELECT HPS. PARTY_SITE_ID PARTNER_SITE_ID, HPS.PARTY_ID PARTNER_ID, HPS.PARTY_SITE_NUMBER TP_SITE_CODE, HPS. LOCATION_ID, 2 PARTNER_TYPE , HPS.LAST_UPDATE_DATE, NULL TIMEZONE_CODE FROM HZ_PARTY_SITES HPS WHERE EXISTS (SELECT 1 FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.PARTY_ID = HPS.PARTY_ID)