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

Object Details

Object Name:	POS_PO_LOCATION_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_PO_LOCATION_DETAIL_V POS.POS_PO_LOCATION_DETAIL_V
Subobject Name:
Status:	VALID

View Type

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

Fetches address information from hr_locations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_ID	NUMBER	(15)	Yes	Location unique identifier
LOCATION_CODE	VARCHAR2	(60)		Location Code
ADDRESS_LINE1	VARCHAR2	(240)		Address Line
ADDRESS_LINE2	VARCHAR2	(240)		Address Line
ADDRESS_LINE3	VARCHAR2	(240)		Address Line
CITY_STATE_ZIP	VARCHAR2	(184)		City State Zip code
COUNTRY	VARCHAR2	(60)		Country

Query Text

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


SELECT LOCATION_ID
,      LOCATION_CODE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY_STATE_ZIP
,      COUNTRY
FROM APPS.POS_PO_LOCATION_DETAIL_V;

Dependencies

[top of page]

APPS.POS_PO_LOCATION_DETAIL_V references the following:

APPS: HR_LOCATIONS_ALL

APPS.POS_PO_LOCATION_DETAIL_V is not referenced by any database object