GaramX

CREATE UNIQUE INDEX AK_PEE_RATER_TARGET ON PEE_RATER_TARGET (APPR_ID, RATEE_EMP_NO)

DECLARE 
  AV_RET_CODE VARCHAR2(4000);
  AV_RET_MESSAGE VARCHAR2(4000);
BEGIN 
  EHR_DSEC.P_MAKE_ENTITY ( '업무구분', '시퀀스명', '테이블명', 'EHR_DSEC', AV_RET_CODE, AV_RET_MESSAGE );
  p_make_entity( 'CNM', 'S_CNM_SEQUENCE', 'CNM_CAR_ASSET', AV_RET_CODE, AV_RET_MESSAGE );
END; 
COMMIT;

엔티티관련 Table

SELECT *
FROM FRM_ENTITY
ORDER BY ENTITY_ID DESC
;
 
SELECT *
FROM FRM_ENTITY_COLUMN
WHERE ENTITY_ID IN (SELECT ENTITY_ID FROM FRM_ENTITY WHERE ENTITY_NM='EN_PHM_EMP_EXE')
;
 
SELECT *
FROM FRM_ENTITY_COLUMN_MAPPING
WHERE COLUMN_ID IN (
SELECT COLUMN_ID
FROM FRM_ENTITY_COLUMN
WHERE ENTITY_ID IN (SELECT ENTITY_ID FROM FRM_ENTITY WHERE ENTITY_NM='EN_PHM_EMP_EXE')
)
;

DECLARE 
  AV_RET_CODE VARCHAR2(4000);
  AV_RET_MESSAGE VARCHAR2(4000);
BEGIN 
  P_FRM_MESSAGE_COPY ( 'MT_ORM0003_01_06', 'MT_ORM0003_01_07', AV_RET_CODE, AV_RET_MESSAGE );
END; 
COMMIT;

DECLARE 
  AV_RET_CODE VARCHAR2(4000);
  AV_RET_MESSAGE VARCHAR2(4000);
BEGIN
  P_FRM_SQL_COPY ( 'DTM5020_00_R01', 'DTM0041_00_R01', AV_RET_CODE, AV_RET_MESSAGE );
END; 
COMMIT;

DECLARE 
  AV_RET_CODE VARCHAR2(4000);
  AV_RET_MESSAGE VARCHAR2(4000);
BEGIN
  P_FRM_SERVICE_COPY ( 'DTM5020_02_S01', 'DTM0041_02_S01', '9999999', AV_RET_CODE, AV_RET_MESSAGE );
END; 
COMMIT;