View: AP_POL_LOCATIONS_VL

Product:	AP - Payables
Description:	AP_POL_LOCATIONS_VL is a Policy Compliance-specific view that provides multi-lingual support (MLS) for locations that you define for policy schedules. This view allows location data to be available in multiple national languages simultaneou
Implementation/DBA Data:	APPS.AP_POL_LOCATIONS_VL

View Text

SELECT B.ROWID ROW_ID
, B.LOCATION_ID
, B.TERRITORY_CODE
, B.UNDEFINED_LOCATION_FLAG
, B.END_DATE
, B.STATUS
, B.LOCATION_TYPE
, B.COUNTRY
, B.STATE_PROVINCE_ID
, B.COUNTY_ID
, B.CITY_LOCALITY_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, T.LOCATION
, T.DESCRIPTION
FROM AP_POL_LOCATIONS_TL T
, AP_POL_LOCATIONS_B B
WHERE B.LOCATION_ID = T.LOCATION_ID
AND T.LANGUAGE = USERENV('LANG')

Columns