View: JTF_LOC_HIERARCHIES_VL

Product:	JTF - CRM Foundation
Description:	View based on JTF_LOC_HIERARCHIES_B table.
Implementation/DBA Data:	APPS.JTF_LOC_HIERARCHIES_VL

View Text

SELECT B.ROWID ROW_ID
, B.LOCATION_HIERARCHY_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, B.CREATED_BY_APPLICATION_ID
, B.LOCATION_TYPE_CODE
, LTYP.LOCATION_TYPE_NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.AREA1_ID
, B.AREA1_CODE
, LOC1.LOCATION_AREA_NAME AREA1_NAME
, B.AREA2_ID
, B.AREA2_CODE
, LOC2.LOCATION_AREA_NAME AREA2_NAME
, B.COUNTRY_ID
, B.COUNTRY_CODE
, LOC3.LOCATION_AREA_NAME COUNTRY_NAME
, B.COUNTRY_REGION_ID
, B.COUNTRY_REGION_CODE
, LOC4.LOCATION_AREA_NAME COUNTRY_REGION_NAME
, B.STATE_ID
, B.STATE_CODE
, LOC5.LOCATION_AREA_NAME STATE_NAME
, B.STATE_REGION_ID
, B.STATE_REGION_CODE
, LOC6.LOCATION_AREA_NAME STATE_REGION_NAME
, B.CITY_ID
, B.CITY_CODE
, LOC7.LOCATION_AREA_NAME CITY_NAME
, B.POSTAL_CODE_ID
, PCODE.POSTAL_CODE_START
, PCODE.POSTAL_CODE_END
FROM JTF_LOC_HIERARCHIES_B B
, JTF_LOC_TYPES_VL LTYP
, JTF_LOC_AREAS_TL LOC1
, JTF_LOC_AREAS_TL LOC2
, JTF_LOC_AREAS_TL LOC3
, JTF_LOC_AREAS_TL LOC4
, JTF_LOC_AREAS_TL LOC5
, JTF_LOC_AREAS_TL LOC6
, JTF_LOC_AREAS_TL LOC7
, JTF_LOC_POSTAL_CODES PCODE
WHERE B.LOCATION_TYPE_CODE = LTYP.LOCATION_TYPE_CODE
AND B.AREA1_ID = LOC1.LOCATION_AREA_ID (+)
AND LOC1.LANGUAGE(+) = USERENV('LANG')
AND B.AREA2_ID = LOC2.LOCATION_AREA_ID(+)
AND LOC2.LANGUAGE(+) = USERENV('LANG')
AND B.COUNTRY_ID = LOC3.LOCATION_AREA_ID(+)
AND LOC3.LANGUAGE(+) = USERENV('LANG')
AND B.COUNTRY_REGION_ID = LOC4.LOCATION_AREA_ID(+)
AND LOC4.LANGUAGE(+) = USERENV('LANG')
AND B.STATE_ID = LOC5.LOCATION_AREA_ID(+)
AND LOC5.LANGUAGE(+) = USERENV('LANG')
AND B.STATE_REGION_ID = LOC6.LOCATION_AREA_ID(+)
AND LOC6.LANGUAGE(+) = USERENV('LANG')
AND B.CITY_ID = LOC7.LOCATION_AREA_ID(+)
AND LOC7.LANGUAGE(+) = USERENV('LANG')
AND B.POSTAL_CODE_ID = PCODE.LOCATION_POSTAL_CODE_ID(+)

Columns