WMS ASN DISCREPANCY

select 
shipment_num,
item_id,
nvl(to_char(quantity_expected),' ') quantity_expected,
nvl(to_char(quantity_actual),' ')   quantity_actual,
nvl(unit_of_measure_expected,' ') unit_of_measure_expected,
nvl(unit_of_measure_actual,' ') unit_of_measure_actual,
lpn_expected,
lpn_actual,
nvl(item_revision_expected,' ') item_revision_expected ,
nvl(item_revision_actual,' ' ) item_revision_actual ,
lot_number_expected,
lot_number_actual,
vendor_id, 
	WMS_WMSASNI_XMLP_PKG.cf_2formula(item_id) CF_2, 
	WMS_WMSASNI_XMLP_PKG.cf_9formula(vendor_id) CF_9
from
  wms_asn_details asn
where  asn.organization_id = :ORG_ID
  and  asn.item_id = nvl(:P_ITEM_ID,asn.item_id)
  and  asn.shipment_num = nvl(:P_SHIPMENT_NUMBER,asn.shipment_num)
  and  (
             ( asn.vendor_id = :P_VENDOR_ID and :P_VENDOR_ID is not null)
             or 
             (:P_VENDOR_ID is null)
          ) 
 and  (
            ( asn.vendor_site_id = :P_VENDOR_SITE_ID and :P_VENDOR_SITE_ID is not null)
            or 
           (:P_VENDOR_SITE_ID is null)
          )
 and  (
             (  (  trunc(asn.TRANSACTION_DATE)  between  trunc(:P_FROM_DATE)
 and trunc(:P_END_DATE)  )
               and 
            (:P_FROM_DATE is not null or :P_END_DATE is not null)
              )
             or 
             (:P_FROM_DATE is null and :P_END_DATE is null)
          )
 and   (    
            ( nvl (:P_SHOW_ONLY_DISC,'N') = 'N' and discrepancy_status = discrepancy_status ) 
            or
           ( nvl (:P_SHOW_ONLY_DISC,'N') = 'Y' and discrepancy_status in ('E' ,'F')  ) 
        )
  and  discrepancy_reporting_context = 'I'