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.JTF_LOC_HIERARCHIES_VL

Object Details

Object Name:	JTF_LOC_HIERARCHIES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_LOC_HIERARCHIES_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View based on JTF_LOC_HIERARCHIES_B table. Stores information about what geographic location hierarchies are available to be used in Oracle Marketing.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row id of the table.
LOCATION_HIERARCHY_ID	NUMBER		Yes	Unique identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for locking purposes.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
CREATED_BY_APPLICATION_ID	NUMBER		Yes	Identifier of the application that created record.
LOCATION_TYPE_CODE	VARCHAR2	(30)	Yes	Foreign key to table JTF_LOC_TYPES_B.
LOCATION_TYPE_NAME	VARCHAR2	(240)	Yes	Name of the location type.
START_DATE_ACTIVE	DATE		Yes	The date on which the hierarchy record becomes active.
END_DATE_ACTIVE	DATE			The date until which the hierarchy record remains active.
AREA1_ID	NUMBER			Identifier of AREA1-type location area.
AREA1_CODE	VARCHAR2	(30)		Short name of AREA1-type location area that AREA1_ID identifies.
AREA1_NAME	VARCHAR2	(240)		Name of AREA1-type location area that AREA1_ID identifies.
AREA2_ID	NUMBER			Identifier of AREA2-type location area.
AREA2_CODE	VARCHAR2	(30)		Short name of AREA2-type location area that AREA2_ID identifies.
AREA2_NAME	VARCHAR2	(240)		Name of AREA2-type location area that AREA2_ID identifies.
COUNTRY_ID	NUMBER			Identifier of COUNTRY-type location area.
COUNTRY_CODE	VARCHAR2	(30)		Short name of COUNTRY-type location area that COUNTRY_ID identifies.
COUNTRY_NAME	VARCHAR2	(240)		Name of COUNTRY-type location area that COUNTRY_ID identifies.
COUNTRY_REGION_ID	NUMBER			Identifier of COUNTRY_REGION-type location area.
COUNTRY_REGION_CODE	VARCHAR2	(30)		Short name of COUNTRY_REGION-type location area that COUNTRY_REGION_ID identifies.
COUNTRY_REGION_NAME	VARCHAR2	(240)		Name of COUNTRY_REGION-type location area that COUNTRY_REGION_ID identifies.
STATE_ID	NUMBER			Identifier of STATE-type location area.
STATE_CODE	VARCHAR2	(30)		Short name of STATE-type location area that STATE_ID identifies.
STATE_NAME	VARCHAR2	(240)		Name of STATE-type location area that STATE_ID identifies.
STATE_REGION_ID	NUMBER			Identifier of STATE_REGION-type location area.
STATE_REGION_CODE	VARCHAR2	(30)		Short name of STATE_REGION-type location area that STATE_REGION_ID identifies.
STATE_REGION_NAME	VARCHAR2	(240)		Name of STATE_REGION-type location area that STATE_REGION_ID identifies.
CITY_ID	NUMBER			Identifier of CITY-type location area.
CITY_CODE	VARCHAR2	(30)		Short name of CITY-type location area that CITY_ID identifies.
CITY_NAME	VARCHAR2	(240)		Name of CITY-type location area that CITY_ID identifies.
POSTAL_CODE_ID	NUMBER			Identifier of POSTAL_CODE-type location area.
POSTAL_CODE_START	VARCHAR2	(6)		Indicates the beginning of a postal code range.
POSTAL_CODE_END	VARCHAR2	(6)		Indicates the end of a postal code range.

Query Text

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


SELECT ROW_ID
,      LOCATION_HIERARCHY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY_APPLICATION_ID
,      LOCATION_TYPE_CODE
,      LOCATION_TYPE_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      AREA1_ID
,      AREA1_CODE
,      AREA1_NAME
,      AREA2_ID
,      AREA2_CODE
,      AREA2_NAME
,      COUNTRY_ID
,      COUNTRY_CODE
,      COUNTRY_NAME
,      COUNTRY_REGION_ID
,      COUNTRY_REGION_CODE
,      COUNTRY_REGION_NAME
,      STATE_ID
,      STATE_CODE
,      STATE_NAME
,      STATE_REGION_ID
,      STATE_REGION_CODE
,      STATE_REGION_NAME
,      CITY_ID
,      CITY_CODE
,      CITY_NAME
,      POSTAL_CODE_ID
,      POSTAL_CODE_START
,      POSTAL_CODE_END
FROM APPS.JTF_LOC_HIERARCHIES_VL;

Dependencies

[top of page]

APPS.JTF_LOC_HIERARCHIES_VL references the following:

APPS: JTF_LOC_AREAS_TL; JTF_LOC_HIERARCHIES_B; JTF_LOC_POSTAL_CODES; JTF_LOC_TYPES_VL

APPS.JTF_LOC_HIERARCHIES_VL is referenced by following:

APPS: AMS_ACT_GEO_AREAS_V; AMS_CPYUTILITY_PVT - show dependent code; AMS_GEOAREA_SCR_V; AMS_SOURCECODE_PVT - show dependent code; AMS_UTILITY_PVT - show dependent code; OZF_FUND_UTILIZED_PUB - show dependent code; OZF_UTILITY_PVT - show dependent code; PV_PARTNER_GEO_MATCH_PVT - show dependent code; PV_PRGM_CONTRACTS_PVT - show dependent code; PV_PRGM_PMT_MODE_PVT - show dependent code; PV_USER_RESP_PVT - show dependent code