SELECT 0  SEL,             A.SK_NO,            C.ITEM_NM,
     C.SPEC,             C.QTY_UNT,          D.NICK_NAME,
     A.REQ_QTY,
     DECODE(NVL(A.APP_QTY,0),0,A.REQ_QTY,A.APP_QTY),
     A.TITO_CD,          AAA3.TITO_NM        TITO_NM,
     A.PL_PJ_MK,         A.PL_PJ_CD,
     DECODE(A.PL_PJ_MK, '1', AAA1.PL_NM, '') PL_PJ_NM,
     A.STATUS,           BCD1.ADM_CDNM,      A.TO_NO,
     A.REQ_NO,           A.REQ_DATE, A.REQ_REMARK
FROM BDC01IT A,          BEB02MT C,          AAM01MT BCD1,
     AAA02MT AAA1,       AAD01MT AAA3,       ZAA01MT D
------------------------ co ma być w Trim ????????????????
  WHERE NVL(A.APP_EMP,'1')  LIKE '" & Trim(txtApp_Emp) & "%'   AND
 A.STATUS            =1
 AND A.LOC_BIZ           = '10'
 AND A.SK_NO             = C.SK_NO(+)
 AND A.PL_PJ_CD          = AAA1.PL_CD(+)
 AND A.TITO_CD           = AAA3.TITO_CD(+)
 AND A.STATUS            = BCD1.ADM_CD(+)
 AND BCD1.ADM_MK(+)      = '09'
 AND NVL(A.TI_CLASS,'1') IN ('1','2','9')
 AND A.REQ_EMP           = D.EMP_NO;