1. Tables and Views for SCM
  2. MSC_AP_CUSTOMER_SITES_V

MSC_AP_CUSTOMER_SITES_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

PARTNER_SITE_ID

PARTNER_NAME

TP_SITE_CODE

LOCATION_CODE

PARTNER_TYPE

DELETED_FLAG

LAST_UPDATE_DATE

Query

SQL_Statement

SELECT HPS. PARTY_SITE_ID PARTNER_SITE_ID,

HP.PARTY_NUMBER PARTNER_NAME,

HPS.PARTY_SITE_NUMBER TP_SITE_CODE,

HPS.LOCATION_ID LOCATION_CODE,

2 PARTNER_TYPE,

(CASE WHEN HPS.END_DATE_ACTIVE < SYSDATE OR HPS.START_DATE_ACTIVE > SYSDATE THEN 1 ELSE 2 END) DELETED_FLAG,

HPS.LAST_UPDATE_DATE

FROM HZ_PARTY_SITES HPS,

HZ_PARTIES HP

WHERE HPS.PARTY_ID = HP.PARTY_ID

AND EXISTS

(SELECT 1 FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.PARTY_ID = HPS.PARTY_ID

)