SELECT ORGH_ORGHRCHY_FK ORGH_ORGHRCHY_FK ,ORGH_GLOBAL_FLAG ORGH_GLOBAL_FLAG ,ORGH_ORGHVRSN_FK ORGH_ORGHVRSN_FK ,ORGH_SUP_ORGANZTN_FK ORGH_SUP_ORGANZTN_FK ,ORGH_SUP_LEVEL ORGH_SUP_LEVEL ,ORGH_SUP_SUB1_ORGANZTN_FK ORGH_SUP_SUB1_ORGANZTN_FK ,ORGH_SUP_SUB2_ORGANZTN_FK ORGH_SUP_SUB2_ORGANZTN_FK ,ORGH_SUP_SUB3_ORGANZTN_FK ORGH_SUP_SUB3_ORGANZTN_FK ,ORGH_SUP_SUB4_ORGANZTN_FK ORGH_SUP_SUB4_ORGANZTN_FK ,ORGH_ORGANZTN_FK ORGH_ORGANZTN_FK ,ORGH_LEVEL ORGH_LEVEL ,ORGH_RELATIVE_LEVEL ORGH_RELATIVE_LEVEL FROM HRI_CS_ORGH_CT WHERE ORGH_SUB_NODE_HAS_WORKERS_FLAG = 'Y' WITH READ ONLY
SELECT ORGH_ORGHRCHY_FK ORGH_ORGHRCHY_FK
, ORGH_GLOBAL_FLAG ORGH_GLOBAL_FLAG
, ORGH_ORGHVRSN_FK ORGH_ORGHVRSN_FK
, ORGH_SUP_ORGANZTN_FK ORGH_SUP_ORGANZTN_FK
, ORGH_SUP_LEVEL ORGH_SUP_LEVEL
, ORGH_SUP_SUB1_ORGANZTN_FK ORGH_SUP_SUB1_ORGANZTN_FK
, ORGH_SUP_SUB2_ORGANZTN_FK ORGH_SUP_SUB2_ORGANZTN_FK
, ORGH_SUP_SUB3_ORGANZTN_FK ORGH_SUP_SUB3_ORGANZTN_FK
, ORGH_SUP_SUB4_ORGANZTN_FK ORGH_SUP_SUB4_ORGANZTN_FK
, ORGH_ORGANZTN_FK ORGH_ORGANZTN_FK
, ORGH_LEVEL ORGH_LEVEL
, ORGH_RELATIVE_LEVEL ORGH_RELATIVE_LEVEL
FROM HRI_CS_ORGH_CT
WHERE ORGH_SUB_NODE_HAS_WORKERS_FLAG = 'Y' WITH READ ONLY
|
|
|