SELECT A.SUBSTR(ITEM_ID,5,8)AS PN, A.SUPLY_AVAIL_CAT, A.TOTQTY_WAC, A.WAC_UNIT_PRICE,B.part_type,B.pn_name,B.bsns_group_id,B.div_cod
FROM COPPC.COINS_ACTUAL_WAC A , COPPI.PDM_PART B
WHERE (A.ITEM_ID =B.ITEM_ID)
AND FIN_OU_WACLVL = 'CEN'
AND SUPLY_AVAIL_CAT = 'NEW'
AND DIV_COD='71'