VIEW: APPS.OE_INLINE_FOUR_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 , PARENT.LOCATION_SEGMENT_ID PARENT_ID , PARENT.LOCATION_SEGMENT_VALUE PARENT_VALUE , PARENT.LOCATION_SEGMENT_USER_VALUE PARENT_USER_VALUE , PARENT.LOCATION_STRUCTURE_ID PARENT_LOC_STRUCTURE_ID , GRAND_PARENT.LOCATION_SEGMENT_ID GRAND_PARENT_ID , GRAND_PARENT.LOCATION_SEGMENT_VALUE GRAND_PARENT_VALUE , GRAND_PARENT.LOCATION_SEGMENT_USER_VALUE GRAND_PARENT_USER_VALUE , GRAND_PARENT.LOCATION_STRUCTURE_ID GRAND_PARENT_LOC_STRUCT_ID , GREAT_GRAND_PARENT.LOCATION_SEGMENT_ID GREAT_GRAND_PARENT_ID , GREAT_GRAND_PARENT.LOCATION_SEGMENT_VALUE GREAT_GRAND_PARENT_VALUE , GREAT_GRAND_PARENT.LOCATION_SEGMENT_USER_VALUE GREAT_GRAND_PARENT_USER_VALUE , GREAT_GRAND_PARENT.LOCATION_STRUCTURE_ID GREAT_GRA_PAR_LOC_STRUCT_ID FROM AR_LOCATION_VALUES CHILD, AR_LOCATION_VALUES PARENT, AR_LOCATION_VALUES GRAND_PARENT, AR_LOCATION_VALUES GREAT_GRAND_PARENT WHERE CHILD.PARENT_SEGMENT_ID = PARENT.LOCATION_SEGMENT_ID AND PARENT.PARENT_SEGMENT_ID = GRAND_PARENT.LOCATION_SEGMENT_ID AND GRAND_PARENT.LOCATION_SEGMENT_ID = GREAT_GRAND_PARENT.LOCATION_SEGMENT_ID AND CHILD.LOCATION_STRUCTURE_ID=PARENT.LOCATION_STRUCTURE_ID AND PARENT.LOCATION_STRUCTURE_ID=GRAND_PARENT.LOCATION_STRUCTURE_ID AND GRAND_PARENT.LOCATION_STRUCTURE_ID=GREAT_GRAND_PARENT.LOCATION_STRUCTURE_ID

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
, PARENT.LOCATION_SEGMENT_ID PARENT_ID
, PARENT.LOCATION_SEGMENT_VALUE PARENT_VALUE
, PARENT.LOCATION_SEGMENT_USER_VALUE PARENT_USER_VALUE
, PARENT.LOCATION_STRUCTURE_ID PARENT_LOC_STRUCTURE_ID
, GRAND_PARENT.LOCATION_SEGMENT_ID GRAND_PARENT_ID
, GRAND_PARENT.LOCATION_SEGMENT_VALUE GRAND_PARENT_VALUE
, GRAND_PARENT.LOCATION_SEGMENT_USER_VALUE GRAND_PARENT_USER_VALUE
, GRAND_PARENT.LOCATION_STRUCTURE_ID GRAND_PARENT_LOC_STRUCT_ID
, GREAT_GRAND_PARENT.LOCATION_SEGMENT_ID GREAT_GRAND_PARENT_ID
, GREAT_GRAND_PARENT.LOCATION_SEGMENT_VALUE GREAT_GRAND_PARENT_VALUE
, GREAT_GRAND_PARENT.LOCATION_SEGMENT_USER_VALUE GREAT_GRAND_PARENT_USER_VALUE
, GREAT_GRAND_PARENT.LOCATION_STRUCTURE_ID GREAT_GRA_PAR_LOC_STRUCT_ID
FROM AR_LOCATION_VALUES CHILD
, AR_LOCATION_VALUES PARENT
, AR_LOCATION_VALUES GRAND_PARENT
, AR_LOCATION_VALUES GREAT_GRAND_PARENT
WHERE CHILD.PARENT_SEGMENT_ID = PARENT.LOCATION_SEGMENT_ID
AND PARENT.PARENT_SEGMENT_ID = GRAND_PARENT.LOCATION_SEGMENT_ID
AND GRAND_PARENT.LOCATION_SEGMENT_ID = GREAT_GRAND_PARENT.LOCATION_SEGMENT_ID
AND CHILD.LOCATION_STRUCTURE_ID=PARENT.LOCATION_STRUCTURE_ID
AND PARENT.LOCATION_STRUCTURE_ID=GRAND_PARENT.LOCATION_STRUCTURE_ID
AND GRAND_PARENT.LOCATION_STRUCTURE_ID=GREAT_GRAND_PARENT.LOCATION_STRUCTURE_ID