AR Invoices against Sales Orders In Oracle Apps

The below query returns AR Invoices against Sales Orders In Oracle Apps.

---------------------------------------------------------------------------------
SELECT HR.NAME OU,
HP.PARTY_NAME,
HZCA.ACCOUNT_NUMBER CUSTOMER_NUMBER,
ORDER_NUMBER,
ORDERED_DATE,
LOCATION,
HZCST.SITE_USE_CODE,
INVOICE_DET.TRX_NUMBER INVNO,
INVOICE_DET.TRX_DATE INVDATE,PARTY_SITE.PARTY_SITE_NUMBER SITNO
FROM HZ_CUST_ACCOUNTS HZCA,
HZ_PARTY_SITES PARTY_SITE ,
HZ_LOCATIONS LOC ,
HZ_CUST_ACCT_SITES_ALL HZCS,
HZ_CUST_SITE_USES_ALL HZCST,
HZ_PARTIES HP,
OE_ORDER_HEADERS_ALL OEH,
HR_OPERATING_UNITS HR,
(SELECT CT_REFERENCE,TRX_NUMBER,TRX_DATE FROM RA_CUSTOMER_TRX_ALL) INVOICE_DET
WHERE HZCA.CUST_ACCOUNT_ID = HZCS.CUST_ACCOUNT_ID
AND HZCS.CUST_ACCT_SITE_ID =HZCST.CUST_ACCT_SITE_ID
AND INVOICE_DET.CT_REFERENCE=TO_CHAR(ORDER_NUMBER)
AND HZCS.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND HZCS.CUST_ACCT_SITE_ID =HZCST.CUST_ACCT_SITE_ID
AND HP.PARTY_ID = HZCA.PARTY_ID
AND HZCST.ORG_ID = HR.ORGANIZATION_ID
AND HZCA.CUST_ACCOUNT_ID =OEH.SOLD_TO_ORG_ID
AND HZCST.SITE_USE_ID =OEH.INVOICE_TO_ORG_ID
--INVOICE TO OEH.INVOICE_TO_ORG_ID
--SHIP TO OEH.ship_to_org_id
AND HZCS.STATUS = 'A'
AND HZCST.STATUS = 'A'

---------------------------------------------------------------------------------

If you want to display the Bill to and Ship to address both then add another union and replace OEH.INVOICE_TO_ORG_ID with OEH.ship_to_org_id