SELECT DISTINCT GE.APPLY_TYPE_ID,P.*, GE.ENDO_ID GEN_ENDO_ID, S.STATUS_NAME, R.BIZ_PRDT_CODE, TO_CHAR(GE.EFF_DATE, 'dd/mm/yyyy') ENDO_EFF_DATE, GE.CREATOR_ID ENDO_CREAOR FROM T_POLICY_GENERAL_LOG P, T_GEN_POLICY_STATUS S, T_PRODUCT_GENERAL R, T_GEDO_ENDORSEMENT GEWHERE S.STATUS_ID = P.STATUS_ID AN
管理
