|
SELECT a.recname FROM psrecfield a , PSRECDEFN b , psrecfield d , psrecfield c WHERE a.fieldname = 'BUSINESS_UNIT' AND (a.edittable='SP_BU_OM_NONVW' OR a.edittable='SP_BU_OM_CLSVW' OR a.edittable='SP_BU_OM_OPRVW' OR a.edittable='BUS_UNIT_TBL_OM') AND a.fieldnum = 1 AND a.recname = b.recname AND b.rectype = 0 AND b.recname NOT LIKE 'AUDIT%' AND b.recname NOT IN ('RMA_PRCADJ_DATE','RMA_PRCADJ_DTL','RMA_PRCADJ_FORM','RMA_PRICE_ADJST') AND d.recname = a.recname AND d.fieldnum = 3 AND d.fieldname = 'RMA_LINE_NBR' AND c.recname = a.recname AND c.fieldnum = 2 AND c.fieldname = 'RMA_ID'
|