Query to extract Active BOL_NOTES for all Active Customers

SELECT hp.party_name “CUSTOMER_NAME”,
fdv.category_description “Catergory Description”, fdv.document_id,
fdv.title, fdst.short_text, fdst.media_id, oarev.attribute_name,
oarev.attribute_valfdst.short_textue
FROM apps.fnd_documents_vl fdv,
apps.fnd_documents_short_text fdst,
apps.oe_attachment_rules_v oarv,
apps.oe_attachment_rule_elements_v oarev,
apps.hz_cust_site_uses_all hcsua,
apps.hz_cust_acct_sites_all hcasa,
apps.hz_cust_accounts hca,
apps.hz_parties hp
WHERE 1 = 1
AND fdv.media_id = fdst.media_id
AND (fdv.end_date_active IS NULL OR fdv.end_date_active >= SYSDATE)
AND fdv.document_id = oarv.document_id
AND oarv.rule_id = oarev.rule_id
AND oarev.attribute_value = TO_CHAR (hcsua.site_use_id)
AND hp.party_id = hca.party_id
AND hca.cust_account_id = hcasa.cust_account_id
AND hcasa.cust_acct_site_id = hcsua.cust_acct_site_id
AND hp.status = ‘A’
AND hcsua.status = ‘A’;