SELECT LOC.LOCATION_STRUCTURE_ID , LOC.LOCATION_SEGMENT_QUALIFIER , LOC.LOCATION_SEGMENT_ID , LOC.LOCATION_SEGMENT_VALUE , LOC.LOCATION_SEGMENT_USER_VALUE , LOC.LOCATION_SEGMENT_DESCRIPTION , LOC_PARENT.LOCATION_SEGMENT_USER_VALUE PARENT , LOC_PARENT.LOCATION_SEGMENT_DESCRIPTION PARENT_DESC FROM AR_LOCATION_VALUES LOC, AR_LOCATION_VALUES LOC_PARENT WHERE LOC.PARENT_SEGMENT_ID = LOC_PARENT.LOCATION_SEGMENT_ID
SELECT LOC.LOCATION_STRUCTURE_ID
, LOC.LOCATION_SEGMENT_QUALIFIER
, LOC.LOCATION_SEGMENT_ID
, LOC.LOCATION_SEGMENT_VALUE
, LOC.LOCATION_SEGMENT_USER_VALUE
, LOC.LOCATION_SEGMENT_DESCRIPTION
, LOC_PARENT.LOCATION_SEGMENT_USER_VALUE PARENT
, LOC_PARENT.LOCATION_SEGMENT_DESCRIPTION PARENT_DESC
FROM AR_LOCATION_VALUES LOC
, AR_LOCATION_VALUES LOC_PARENT
WHERE LOC.PARENT_SEGMENT_ID = LOC_PARENT.LOCATION_SEGMENT_ID
|
|
|