OKC_SEARCH_PARTIES

Details

Schema: FUSION
Object owner: OKC
Object type: VIEW

Columns

Name
PARTY_ID PARTY_NAME PARTY_NUMBER PARTY_TYPE STATUS

Name

PARTY_ID

PARTY_NAME

PARTY_NUMBER

PARTY_TYPE

STATUS

Query

SQL_Statement
SELECT p.PARTY_ID, p.PARTY_NAME, p.PARTY_NUMBER, p.PARTY_TYPE, p.status FROM HZ_PARTIES p WHERE ( EXISTS ( SELECT 'Y' FROM HZ_PARTY_USG_ASSIGNMENTS a WHERE p.party_id = a.party_id AND a.PARTY_USAGE_CODE IN ('EXTERNAL_LEGAL_ENTITY', 'SUPPLIER','PARTNER', 'INACTIVE_PARTNER', 'SALES_PROSPECT', 'SALES_ACCOUNT', 'CUSTOMER', 'LEGAL_ENTITY') ) OR EXISTS ( SELECT 'Y' FROM hz_cust_accounts cust, fun_ic_cust_supp_map fun WHERE cust.party_id = p.party_id AND cust.cust_account_id = fun.cust_account_id ) )

SQL_Statement

SELECT p.PARTY_ID,

p.PARTY_NAME,

p.PARTY_NUMBER,

p.PARTY_TYPE,

p.status

FROM HZ_PARTIES p

WHERE ( EXISTS ( SELECT 'Y'

FROM HZ_PARTY_USG_ASSIGNMENTS a

WHERE p.party_id = a.party_id

AND a.PARTY_USAGE_CODE IN ('EXTERNAL_LEGAL_ENTITY', 'SUPPLIER','PARTNER', 'INACTIVE_PARTNER', 'SALES_PROSPECT', 'SALES_ACCOUNT', 'CUSTOMER', 'LEGAL_ENTITY')

)

OR

EXISTS ( SELECT 'Y'

FROM hz_cust_accounts cust, fun_ic_cust_supp_map fun

WHERE cust.party_id = p.party_id

AND cust.cust_account_id = fun.cust_account_id

)