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

VIEW: APPS.PN_LOCATIONS_ITF_V

Object Details
Object Name: PN_LOCATIONS_ITF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPN.PN_LOCATIONS_ITF_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER
Yes Uniquely identifies a location row. The value is populated using sequence PN_LOCATIONS_S
LOCATION_TYPE_LOOKUP_CODE VARCHAR2 (30) Yes Type of location, such as building, floor, office, etc. The value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_LOCATION_TYPE
LOCATION_CODE VARCHAR2 (90) Yes Another way of uniquely identifying a location. The locations are classified as: BUILDING, FLOOR and OFFICE. Oracle Property Manager generates this unique code based on the input provided by the user in the location_alias data element. If the location_alias for the building row is 3OP, the location code for the building is created as 3OP. For a floor in the same building, if the location_alias is -02 then the floor's location code is created as 3OP-2. For an office on the same floor, if the location_alias is -201 then the office location code is created as 3OP-02-201.
BUILDING VARCHAR2 (50)
Name of the building. This data element is null for a floor and an office row
LEASE_OR_OWNED VARCHAR2 (30)
Identifies whether the property is leased or owned or mixed or managed. Valid values : L------ Leased, MG------ Managed, MI------ Mixed, O------ Owned
FLOOR VARCHAR2 (20)
Name of the floor, for example, 'First Floor' or '01'. This data element is null for a building and an office row.
OFFICE VARCHAR2 (20)
Name of the office, for example, ' CEO's Office' or '01'. This data element is null for a floor and building row.
ADDRESS_LINE1 VARCHAR2 (240)
First line of an address
ADDRESS_LINE2 VARCHAR2 (240)
Second line of an address
ADDRESS_LINE3 VARCHAR2 (240)
Third line of an address
ADDRESS_LINE4 VARCHAR2 (240)
Fourth line of an address
COUNTY VARCHAR2 (60)
County
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
ZIP_CODE VARCHAR2 (60)
Postal Code
COUNTRY VARCHAR2 (60)
Country
ADDRESS_STYLE VARCHAR2 (30)
Used as context value for Flexible Address Format descriptive flexfield
MAX_CAPACITY NUMBER

Maximum capacity for this location. Oracle Property Manager uses this data element to identify the number of people a location can hold.
OPTIMUM_CAPACITY NUMBER

Optimum capacity for this location. This number cannot be greater than the maximum.
RENTABLE_AREA NUMBER

Rentable area of this location.
USABLE_AREA NUMBER

Usable area of this location. Usable area cannot be greater than rentable area.
ALLOCATE_COST_CENTER_CODE VARCHAR2 (30)
The cost center to which this location is allocated
UOM_CODE VARCHAR2 (3)
The unit of measure used to calculate the area of this location. The value is derived from the lookup_code column in FND_LOOKUPS where lookup_type = PN_UNITS_OF_MEASURE
CONTACT_NAME VARCHAR2 (101)
CONTACT_PHONE VARCHAR2 (35)
EMAIL_ADDRESS VARCHAR2 (240)
DESCRIPTION VARCHAR2 (50)
PARENT_LOCATION_ID NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ADDR_ATTRIBUTE1 VARCHAR2 (150)
ADDR_ATTRIBUTE2 VARCHAR2 (150)
ADDR_ATTRIBUTE3 VARCHAR2 (150)
ADDR_ATTRIBUTE4 VARCHAR2 (150)
ADDR_ATTRIBUTE5 VARCHAR2 (150)
ADDR_ATTRIBUTE6 VARCHAR2 (150)
ADDR_ATTRIBUTE7 VARCHAR2 (150)
ADDR_ATTRIBUTE8 VARCHAR2 (150)
ADDR_ATTRIBUTE9 VARCHAR2 (150)
ADDR_ATTRIBUTE10 VARCHAR2 (150)
ADDR_ATTRIBUTE11 VARCHAR2 (150)
ADDR_ATTRIBUTE12 VARCHAR2 (150)
ADDR_ATTRIBUTE13 VARCHAR2 (150)
ADDR_ATTRIBUTE14 VARCHAR2 (150)
ADDR_ATTRIBUTE15 VARCHAR2 (150)
ORG_ID NUMBER (15)
Query Text

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


SELECT LOCATION_ID
,      LOCATION_TYPE_LOOKUP_CODE
,      LOCATION_CODE
,      BUILDING
,      LEASE_OR_OWNED
,      FLOOR
,      OFFICE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      COUNTY
,      CITY
,      STATE
,      PROVINCE
,      ZIP_CODE
,      COUNTRY
,      ADDRESS_STYLE
,      MAX_CAPACITY
,      OPTIMUM_CAPACITY
,      RENTABLE_AREA
,      USABLE_AREA
,      ALLOCATE_COST_CENTER_CODE
,      UOM_CODE
,      CONTACT_NAME
,      CONTACT_PHONE
,      EMAIL_ADDRESS
,      DESCRIPTION
,      PARENT_LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      ORG_ID
FROM APPS.PN_LOCATIONS_ITF_V;

Dependencies

[top of page]

APPS.PN_LOCATIONS_ITF_V references the following:

SchemaAPPS
SynonymPN_ADDRESSES_ALL
SynonymPN_CONTACTS_ALL
SynonymPN_CONTACT_ASSIGNMENTS_ALL
SynonymPN_LOCATIONS
SynonymPN_PHONES_ALL

APPS.PN_LOCATIONS_ITF_V is not referenced by any database object