EBS Customizations (MOSC)

MOSC Banner

Not getting right party_type

Hi Team, while running below query I'm not getting correct party_type. for my reqrequirement i need party_type should be person.

SELECT
-- xccs.brand,
hp.party_type,
hp.party_id,
-- hr.object_TYPE,
hps.attribute1 CORP_CODE,--ATTRIBUTE1(hz_party_sites)
hps.attribute2 Location,--ATTRIBUTE2(hz_party_sites)
hps.party_site_name Site_Name,---PARTY_SITE_NAME(hz_party_sites)
hl.address1 Address_Line_1,---ADDRESS1(hz_locations)
hl.city,--CITY(hz_locations)
hl.state,---STATE(hz_locations)
hl.postal_code,---POSTAL_CODE(hz_locations)
hca.attribute1 DC,---ATTRIBUTE1(hz_cust_accounts)
hps.party_site_number Site_Number,---PARTY_SITE_NUMBER(hz_party_sites)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center