FND Design Data [Home] [Help]

View: OE_INLINE_ONE_LEVEL_V

Product: ONT - Order Management
Description: Used in Add Customer. Based on table ar_location_values.
Implementation/DBA Data: ViewAPPS.OE_INLINE_ONE_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
, CHILD.COUNTRY_CODE CHILD_COUNTRY_CODE
FROM AR_LOCATION_VALUES CHILD

Columns

Name
LOCATION_STRUCTURE_ID
CHILD_ID
CHILD_VALUE
CHILD_USER_VALUE
CHILD_QUALIFIER
CHILD_COUNTRY_CODE