Customer credit limit at site level

Hi,

Can you please help to correct the below query, i framed this query but it throwing the credit limit at customer header level not the credit limit at site level. I want to extract the credit limit level for a customer account in site level, Please help to correct the below query

SELECT /*decode (h.site_use_id, NULL,'Credit Limit changed at Site

Level','Credit Limit changed at Account Level') "Level",*/

hp.party_name "Customer Name",

hca.account_number "Customer Account Number",

h.credit_limit "Previous Credt Limit",

hcpa.trx_credit_limit "Current Credit Limit",

hcpa.OVERALL_CREDIT_LIMIT, hcpa.ATTRIBUTE2, hcpa.ATTRIBUTE3, hcpa.ATTRIBUTE4,hcpa.site_use_