HZ_CUSTOMER_V

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name
PARTY_ID PARTY_NUMBER

Query

SQL_Statement
SELECT HP.PARTY_ID,HP.PARTY_NUMBER FROM HZ_PARTIES HP, HZ_PARTY_USG_ASSIGNMENTS PUA WHERE HP.PARTY_ID = PUA.PARTY_ID AND PUA.PARTY_USAGE_CODE IN ('CUSTOMER' ,'SALES_ACCOUNT', 'SALES_PROSPECT','LEGAL_ENTITY','EXTERNAL_LEGAL_ENTITY')