OKC_INTER_COMPANY_PARTY_V

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name
PARTY_ID PARTY_NUMBER PARTY_NAME STATUS PARTY_TYPE

Query

SQL_Statement
SELECT hp.party_id, hp.party_number, hp.party_name, hp.status, hp.party_type FROM hz_parties hp WHERE EXISTS ( select 1 from fun_ic_cust_supp_map fun , hz_cust_accounts cust where cust.cust_account_id=fun.cust_account_id and cust.party_id = hp.party_id )