[Home] [Help]
View: AR_LOCVS_LOV_V
Product: | AR - Receivables |
Description: | (Release 10SC Only) |
Implementation/DBA Data: |
APPS.AR_LOCVS_LOV_V
|
View Text
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
Columns
Name |
LOCATION_STRUCTURE_ID |
LOCATION_SEGMENT_QUALIFIER |
LOCATION_SEGMENT_ID |
LOCATION_SEGMENT_VALUE |
LOCATION_SEGMENT_USER_VALUE |
LOCATION_SEGMENT_DESCRIPTION |
PARENT |
PARENT_DESC |