Credit Hold Query -- Oracle Apps

SELECT
DISTINCT HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER,
HP.PARTY_NAME CUSTOMER_NAME,
OHA.ORDER_NUMBER,
OHA.ORDERED_DATE,
OHD.NAME HOLD_NAME,
OHD.TYPE_CODE HOLD_TYPE,
FLV.MEANING RELEASE_REASON_CODE,
FU.USER_NAME RELEASED_BY,
OHR.CREATION_DATE RELEASE_DATE
 FROM
OE_ORDER_HEADERS_ALL OHA,
ONT.OE_ORDER_HOLDS_ALL OOHA,
ONT.OE_HOLD_SOURCES_ALL OHSA,
OE_HOLD_DEFINITIONS OHD,
OE_HOLD_RELEASES OHR,
FND_USER FU,
FND_LOOKUP_VALUES FLV,
HZ_CUST_ACCOUNTS HCA,
HZ_PARTIES HP
WHERE trunc(ORDERED_DATE) BETWEEN TO_DATE(:PFROM,'DD-MON-YYYY') AND TO_DATE(:TDATE,'DD-MON-YYYY')
AND OHA.HEADER_ID=OOHA.HEADER_ID
AND OOHA.HOLD_SOURCE_ID=OHSA.HOLD_SOURCE_ID
AND OHSA.HOLD_ID=OHD.HOLD_ID
AND OOHA.HOLD_RELEASE_ID=OHR.HOLD_RELEASE_ID
AND OHR.CREATED_BY=FU.USER_ID
AND OHR.RELEASE_REASON_CODE=FLV.LOOKUP_CODE
AND FLV.LOOKUP_TYPE='RELEASE_REASON'
and oha.SOLD_TO_ORG_ID=HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID=HP.PARTY_ID
ORDER BY OHA.ORDERED_DATE