[Home] [Help]
View: AR_LOC_TWO_LEVEL_V
View Text
SELECT CHILD.LOCATION_STRUCTURE_ID LOCATION_STRUCTURE_ID
, CHILD.LOCATION_SEGMENT_ID CHILD_ID
, CHILD.LOCATION_SEGMENT_VALUE CHILD_VALUE
, CHILD.LOCATION_SEGMENT_USER_VALUE CHILD_USER_VALUE
, CHILD.LOCATION_SEGMENT_QUALIFIER CHILD_QUALIFIER
, PARENT.LOCATION_SEGMENT_ID PARENT_ID
, PARENT.LOCATION_SEGMENT_VALUE PARENT_VALUE
, PARENT.LOCATION_SEGMENT_USER_VALUE PARENT_USER_VALUE
, CHILD.COUNTRY_CODE COUNTRY_CODE
FROM AR_LOCATION_VALUES CHILD
, AR_LOCATION_VALUES PARENT
WHERE CHILD.PARENT_SEGMENT_ID = PARENT.LOCATION_SEGMENT_ID
AND CHILD.LOCATION_STRUCTURE_ID = PARENT.LOCATION_STRUCTURE_ID
Columns
Name |
LOCATION_STRUCTURE_ID |
CHILD_ID |
CHILD_VALUE |
CHILD_USER_VALUE |
CHILD_QUALIFIER |
PARENT_ID |
PARENT_VALUE |
PARENT_USER_VALUE |
COUNTRY_CODE |