eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CSL_HZ_LOCATIONS_V

Object Details

Object Name:	CSL_HZ_LOCATIONS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Mobile view on HZ_LOCATIONS

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER			Indentifier on CSL_HZ_LOCATIONS_ACC
LOCATION_ID	NUMBER	(15)	Yes	Unique identifier for this location
COUNTRY	VARCHAR2	(60)	Yes	Country code from the TERRITORY_CODE column in the FND_TERRITORY table
ADDRESS1	VARCHAR2	(240)	Yes	First line for address
ADDRESS2	VARCHAR2	(240)		Second line for address
ADDRESS3	VARCHAR2	(240)		Third line for address
ADDRESS4	VARCHAR2	(240)		Fourth line for address
CITY	VARCHAR2	(60)		City
POSTAL_CODE	VARCHAR2	(60)		Postal Code
STATE	VARCHAR2	(60)		State
PROVINCE	VARCHAR2	(60)		Province
COUNTY	VARCHAR2	(60)		County
ADDRESS_LINES_PHONETIC	VARCHAR2	(560)		Phonetic or Kana representation of the Kanji address lines (used in Japan)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCESS_ID
,      LOCATION_ID
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      ADDRESS_LINES_PHONETIC
FROM APPS.CSL_HZ_LOCATIONS_V;

Dependencies

[top of page]

APPS.CSL_HZ_LOCATIONS_V references the following:

APPS: ASG_BASE - show dependent code; CSL_HZ_LOCATIONS_ACC; HZ_LOCATIONS

APPS.CSL_HZ_LOCATIONS_V is not referenced by any database object