VIEW: APPS.HRI_OBI_CS_ORGH_SUP_SUB3_V

Source

View Text - Preformatted

SELECT ORGH_ORGHRCHY_FK ORH3_ORGHRCHY_FK ,ORGH_GLOBAL_FLAG ORH3_GLOBAL_FLAG ,ORGH_ORGHVRSN_FK ORH3_ORGHVRSN_FK ,ORGH_SUP_ORGANZTN_FK ORH3_SUP_ORGANZTN_FK ,ORGH_SUP_LEVEL ORH3_SUP_LEVEL ,ORGH_SUP_SUB1_ORGANZTN_FK ORH3_SUP_SUB1_ORGANZTN_FK ,ORGH_SUP_SUB2_ORGANZTN_FK ORH3_SUP_SUB2_ORGANZTN_FK ,ORGH_ORGANZTN_FK ORH3_ORGANZTN_FK ,ORGH_LEVEL ORH3_LEVEL ,ORGH_RELATIVE_LEVEL ORH3_RELATIVE_LEVEL ,decode(ORGH_RELATIVE_LEVEL,3,'N','Y') ORH3_SUP_DIRECTS_ONLY_FLAG FROM HRI_CS_ORGH_CT WHERE ORGH_RELATIVE_LEVEL <= 3 AND ORGH_SUB_NODE_HAS_WORKERS_FLAG = 'Y' WITH READ ONLY

View Text - HTML Formatted

SELECT ORGH_ORGHRCHY_FK ORH3_ORGHRCHY_FK
, ORGH_GLOBAL_FLAG ORH3_GLOBAL_FLAG
, ORGH_ORGHVRSN_FK ORH3_ORGHVRSN_FK
, ORGH_SUP_ORGANZTN_FK ORH3_SUP_ORGANZTN_FK
, ORGH_SUP_LEVEL ORH3_SUP_LEVEL
, ORGH_SUP_SUB1_ORGANZTN_FK ORH3_SUP_SUB1_ORGANZTN_FK
, ORGH_SUP_SUB2_ORGANZTN_FK ORH3_SUP_SUB2_ORGANZTN_FK
, ORGH_ORGANZTN_FK ORH3_ORGANZTN_FK
, ORGH_LEVEL ORH3_LEVEL
, ORGH_RELATIVE_LEVEL ORH3_RELATIVE_LEVEL
, DECODE(ORGH_RELATIVE_LEVEL
, 3
, 'N'
, 'Y') ORH3_SUP_DIRECTS_ONLY_FLAG
FROM HRI_CS_ORGH_CT
WHERE ORGH_RELATIVE_LEVEL <= 3
AND ORGH_SUB_NODE_HAS_WORKERS_FLAG = 'Y' WITH READ ONLY