[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: |
APPS.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 |