VIEW: APPS.OE_INLINE_ONE_LEVEL_V

Source

View Text - Preformatted

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 ,CHILD.COUNTRY_CODE CHILD_COUNTRY_CODE FROM AR_LOCATION_VALUES CHILD

View Text - HTML Formatted

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
, CHILD.COUNTRY_CODE CHILD_COUNTRY_CODE
FROM AR_LOCATION_VALUES CHILD