FS_JGEN for AR

Hi ,

Our FS_JGEN process for ARDEFN is not picking up data. I see the ITEM's in Question in PS_ITEM_DST_CC_VW .

The GL_DISTRIB Status is N and  I have tried the below SQL's and they return data required.

SELECT *
FROM PS_ITEM_DST D
WHERE EXISTS ( SELECT 'X' FROM PS_ITEM_ACTIVITY A , PS_INSTALLATION I WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT
AND D.CUST_ID = A.CUST_ID AND D.ITEM = '&ITEM'
AND A.ITEM = '&ITEM' AND D.ITEM_LINE = A.ITEM_LINE
AND D.ITEM_SEQ_NUM = A.ITEM_SEQ_NUM AND (I.COMMITMENT_CNTL_AR <> 'Y'