SELECT UFI.SCREEN_INSTANCE_ID AS PARENT_INSTANCE_ID, UFSI.SUB_INSTANCE_ID AS SUB_INSTANCE_ID, PUSI.SCREEN_ID AS PARENT_SCREEN_ID, USI.SCREEN_ID AS CHILD_SCREEN_ID FROM USER_SCREEN_INSTANCES USI INNER JOIN USER_FIELD_SUB_INST_VALUES UFSI ON USI.INSTANCE_ID = UFSI.SUB_INSTANCE_ID INNER JOIN USER_FIELD_INSTANCES UFI ON UFSI.FIELD_INSTANCE_ID = UFI.FIELD_INSTANCE_ID INNER JOIN USER_SCREEN_INSTANCES PUSI ON UFI.SCREEN_INSTANCE_ID = PUSI.INSTANCE_ID