quality report

hi experts,

i am doing report on quality on ud code date.

requirement to to capture all raw material inspection lot record which the usage decison have been done and all pending inspection lot on the same date.

i captured the records based on ud code date but unable to capturing pending lot on the basis of same ud date so please refer related report or guide me.

thank you.