Retrieve Field Activities with Blank Dispatch Group
SELECT * FROM CI_FA fa, ci_sp sp, ci_sp_op_area op
where fa.sp_id=sp.sp_id
and fa_type_cd='INSERT YOUR FA TYPE CD'
and sp.sp_id=op.sp_id
and sp.sp_type_cd='INSERT YOUR SP TYPE CD'
and fa.DISP_GRP_CD = ' '