VIEW: APPS.JTF_LOC_HIERARCHIES_VL

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)