SELECT ORGH_ORGHRCHY_FK ORH0_ORGHRCHY_FK ,ORGH_GLOBAL_FLAG ORH0_GLOBAL_FLAG ,ORGH_ORGHVRSN_FK ORH0_ORGHVRSN_FK ,ORGH_SUP_ORGANZTN_FK ORH0_SUP_ORGANZTN_FK ,ORGH_SUP_LEVEL ORH0_SUP_LEVEL ,ORGH_ORGANZTN_FK ORH0_ORGANZTN_FK ,ORGH_LEVEL ORH0_LEVEL ,ORGH_RELATIVE_LEVEL ORH0_RELATIVE_LEVEL FROM HRI_CS_ORGH_CT WHERE ORGH_RELATIVE_LEVEL = 0 AND ORGH_SUB_NODE_HAS_WORKERS_FLAG = 'Y' WITH READ ONLY
SELECT ORGH_ORGHRCHY_FK ORH0_ORGHRCHY_FK
, ORGH_GLOBAL_FLAG ORH0_GLOBAL_FLAG
, ORGH_ORGHVRSN_FK ORH0_ORGHVRSN_FK
, ORGH_SUP_ORGANZTN_FK ORH0_SUP_ORGANZTN_FK
, ORGH_SUP_LEVEL ORH0_SUP_LEVEL
, ORGH_ORGANZTN_FK ORH0_ORGANZTN_FK
, ORGH_LEVEL ORH0_LEVEL
, ORGH_RELATIVE_LEVEL ORH0_RELATIVE_LEVEL
FROM HRI_CS_ORGH_CT
WHERE ORGH_RELATIVE_LEVEL = 0
AND ORGH_SUB_NODE_HAS_WORKERS_FLAG = 'Y' WITH READ ONLY
|
|
|