# ==========================================================
# DB orphan and deadlink objects check 
# Common part for both, Oracle and Access db's
# ==========================================================

# Use:
# CLL <SOURCE_TABLE> <COMMON_FIELD> <TARGET_TABLE1> <TARGET_TABLE2> ...

CLL CS_INJ INJ_ID CS_RN

CLL CS_SPP RN_ID CS_RN

CLL CS_AT RN_ID CS_RN

CLL CS_CFV RN_ID CS_RN

CLL CS_CG RN_ID CS_RN

#Check CG SO objects
CLL /d=5 CS_SO SO_ID CS_CG CS_RN

CLL CS_PK RN_ID CS_RN

CLL CS_PP RN_ID CS_RN

CLL CS_SCR RN_ID CS_RN

CLL CS_CCR RN_ID CS_RN

CLL CS_TCR RN_ID CS_RN

CLL CS_RD RD_ID CS_RN

#Check RD SO objects
CLL /d=1 CS_SO SO_ID CS_RD CS_RD_SO CS_RN

CLL CS_SP RD_ID CS_RN

#Check SP SO objects
CLL /d=6 CS_SO SO_ID CS_SP CS_RN

CLL CS_MT MT_ID CS_RN

#Check MT SO objects
CLL /d=2 CS_SO SO_ID CS_MT CS_MT_SO CS_RN

CLL CS_SCM MT_ID CS_MT

CLL CS_CCM MT_ID CS_MT

CLL CS_TCM MT_ID CS_MT

CLL CS_SQ SQ_ID CS_RN

#Check SQ SO objects
CLL /d=3 CS_SO SO_ID CS_SQ CS_RN

