|
SELECT D.SETID , D.KIT_ITEM , B.REQUESTOR_ID , D.CHILD_ITM , B.CATALOG_ID ,C.CATEGORY_CD FROM PS_REQUESTOR_CAT B , PS_ITM_CAT_TBL C , PS_PURCH_KIT_TBL D , PS_MASTER_ITEM_TBL E WHERE C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITM_CAT_TBL F WHERE C.SETID = F.SETID AND C.CATEGORY_TYPE = F.CATEGORY_TYPE AND C.CATEGORY_ID = F.CATEGORY_ID AND F.EFF_STATUS = 'A') AND C.SETID = B.SETID AND C.CATEGORY_ID = E.CATEGORY_ID AND C.SETID = E.SETID AND E.SETID = D.SETID AND E.INV_ITEM_ID = D.CHILD_ITM
|