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: ViewPO.POS_PO_LOCATION_DETAIL_V
ViewPOS.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:

SchemaAPPS
SynonymHR_LOCATIONS_ALL

APPS.POS_PO_LOCATION_DETAIL_V is not referenced by any database object