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