Query To Get The Ship To Address By Order Number in Oracle Apps

SELECT DISTINCT LOC.ADDRESS1,LOC.ADDRESS2,HCSUA.LOCATION,H.ORDER_NUMBER,H.CUST_PO_NUMBER,HP.PARTY_NAME,HP.PARTY_NUMBER FROM 

OE_ORDER_HEADERS_ALL H,

HZ_LOCATIONS LOC,

HZ_PARTY_SITES HPS,

HZ_CUST_ACCT_SITES_ALL HCASA,

HZ_CUST_SITE_USES_ALL HCSUA,

HZ_PARTIES HP

WHERE H.SOLD_TO_ORG_ID=HCASA.CUST_ACCOUNT_ID

AND HCSUA.SITE_USE_ID=H.SHIP_TO_ORG_ID

AND LOC.LOCATION_ID=HPS.LOCATION_ID

AND HPS.PARTY_SITE_ID=HCASA.PARTY_SITE_ID

AND HCSUA.CUST_ACCT_SITE_ID=HCASA.CUST_ACCT_SITE_ID

AND HP.PARTY_ID=H.SOLD_TO_ORG_ID

AND H.ORDER_NUMBER='14565';