1 query found for "Maintenance Object Table"
Retrieve all Fields and Tables for Account MO
SELECT T.MAINT_OBJ_CD,
T.TBL_NAME,
TL.DESCR,
T.TBL_ROLE_FLG,
F.FLD_NAME,
FL.DESCRLONG,
FL.LABEL_LONG ,
F.REQUIRED_SW,
F.NULLABLE_SW,
F.VALIDATE_SW
FROM CI_MD_MO M ,
CI_MD_MO_TBL T ,
CI_MD_TBL_L TL ,
CI_MD_TBL_FLD F ,
CI_MD_FLD_L FL
WHERE M.MAINT_OBJ_CD LIKE '%ACCOUNT%'
AND T.MAINT_OBJ_CD = M.MAINT_OBJ_CD
AND F.TBL_NAME = T.TBL_NAME
AND F.TBL_NAME = TL.TBL_NAME
AND FL.FLD_NAME = F.FLD_NAME
ORDER BY TBL_NAME;
uploaded by Nuno Rodrigues