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

Object Details

Object Name:	PN_BUILDINGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_BUILDINGS_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
ROW_ID	ROWID	(10)
ORG_ID	NUMBER	(15)
LOCATION_ID	NUMBER		Yes	Uniquely identifies the location data row.
LAST_UPDATE_DATE	DATE		Yes	Who Column identifies last update date.
LAST_UPDATED_BY	NUMBER		Yes	Who Column identifies last up dated by.
CREATION_DATE	DATE		Yes	Who Column identifies creation date.
CREATED_BY	NUMBER		Yes	Who Column identifies created by.
LAST_UPDATE_LOGIN	NUMBER			Who Column identifies last update login.
LOCATION_PARK_ID	NUMBER			Associates the row in PN_LOCATION_PARKS with the locations row
LOCATION_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Yes	Type of location , such as building , floor office , land , parcel , section. The value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_LOCATION_TYPE
LOCATION_TYPE	VARCHAR2	(80)	Yes	This column contains the meaning from the FND_LOOKUPS table
SPACE_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Type of Space, such as Mail Room , Office Space etc.The Value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_SPACE_TYPE
FUNCTION_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Type of Space, such as Mail Room , Office Space etc.The Value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_FUNCTION_TYPE
STANDARD_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Type of Space, such as Mail Room , Office Space etc.The Value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_STANDARD_TYPE
LOCATION_CODE	VARCHAR2	(90)	Yes	Another way of uniquely identifying the location.The locations are classified as :BUILDING , FLOOR , OFFICE LAND , PARCEL , SECTION. Oracle Property Manager generates this unique code based on the input provided by the user in the location_alias data element.
LOCATION_ALIAS	VARCHAR2	(30)		This data element is used to create the location code for a building , floor , office , land , parcel , section
BUILDING	VARCHAR2	(50)		Name of a building. This data elemet is null for a floor and office row
LEASE_OR_OWNED	VARCHAR2	(30)		Identifies whether the property is leased or owned. Valid values: L - Leased , O - Owned , M - Managed , MI - Mixed
LEASE_OR_OWNED_TENURE	VARCHAR2	(80)
CLASS	VARCHAR2	(30)		Name of the Class List of values available
CLASS_NAME	VARCHAR2	(80)		This captures the meaning from the FND_LOOKUPS table
STATUS_TYPE	VARCHAR2	(30)		Name of the Status_Type List of values available
STATUS_TYPE_NAME	VARCHAR2	(80)		This captures the meaning from the FND_LOOKUPS table
GROSS_AREA	NUMBER			Gross Area to be defined at the Building/Land Level
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
STATUS	VARCHAR2	(1)	Yes	This captures the status of the location as Active or Inactive
PROPERTY_ID	NUMBER			Property ID of the Property List of values from the Property
PROPERTY_NAME	VARCHAR2	(30)		Property Name of the Property
INTERFACE_FLAG	VARCHAR2	(1)		To be used later
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)
UNIT_OF_MEASURE	VARCHAR2	(25)		The unit of measure used to calculate the area of this location
ADDRESS_ID	NUMBER			Uniquely identifies an address row.The value is populated using sequence PN_ADDRESSES_S
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
TERRITORY_ID	NUMBER			Territory identifier
ADDR_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining Column.
ADDR_ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ADDR_ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment column.
TERRITORY_SHORT_NAME	VARCHAR2	(80)		This captures the name of the Country
CONCATENATED_ADDRESS	VARCHAR2	(4000)		This captures the address part
OFFICE_PARK_ID	NUMBER			This picks up the value from the FND_LOOKUPS table where LOOKUP_CODE = OFFICE PARK
OFFICE_PARK_NAME	VARCHAR2	(50)		This picks up the meaning from the FND_LOOKUPS table where LOOKUP_CODE = OFFICE PARK
REGION_ID	NUMBER			This picks up the value from the FND_LOOKUPS table where LOOKUP_CODE = REGION
REGION_NAME	VARCHAR2	(50)		This picks up the meaning from the FND_LOOKUPS table where LOOKUP_CODE = REGION
VACANT_AREA	NUMBER			This is a computed column
LOAD_FACTOR	NUMBER			This is a computed column
PRCT_VACANT	NUMBER			This is a computed column
UTILIZED_CAPACITY	NUMBER			This is a computed column
VACANCY	NUMBER			This is a computed column
OCCUPANCY	NUMBER			This is a computed column
AREA_UTILIZED	NUMBER			This is a computed column
FLOORS	NUMBER			This is a computed column
UNITS	NUMBER			This is a computed column
ACTIVE_START_DATE	DATE		Yes
ACTIVE_END_DATE	DATE
OCCUPANCY_STATUS_CODE	VARCHAR2	(30)		The occupancy status of a location. It can be Y (occupiable) or N (not occupiable)
OCCUPANCY_STATUS	VARCHAR2	(80)
ASSIGNABLE_EMP	VARCHAR2	(30)		Indicates if the location can be assigned to an employee. Valid values are Y and N
ASSIGNABLE_CC	VARCHAR2	(30)		Indicates if the location can be assigned to a Cost Center. Valid values are Y and N
ASSIGNABLE_CUST	VARCHAR2	(30)		Indicates if the location can be assigned to a customer. Valid values are Y and N
DISPOSITION_CODE	VARCHAR2	(30)		Indicates the disposition of a location
DISPOSITION	VARCHAR2	(80)
ACC_TREATMENT_CODE	VARCHAR2	(30)		Indicates the accounting treatment of a location
ACC_TREATMENT	VARCHAR2	(80)

Query Text

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


SELECT ROW_ID
,      ORG_ID
,      LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOCATION_PARK_ID
,      LOCATION_TYPE_LOOKUP_CODE
,      LOCATION_TYPE
,      SPACE_TYPE_LOOKUP_CODE
,      FUNCTION_TYPE_LOOKUP_CODE
,      STANDARD_TYPE_LOOKUP_CODE
,      LOCATION_CODE
,      LOCATION_ALIAS
,      BUILDING
,      LEASE_OR_OWNED
,      LEASE_OR_OWNED_TENURE
,      CLASS
,      CLASS_NAME
,      STATUS_TYPE
,      STATUS_TYPE_NAME
,      GROSS_AREA
,      UOM_CODE
,      STATUS
,      PROPERTY_ID
,      PROPERTY_NAME
,      INTERFACE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      UNIT_OF_MEASURE
,      ADDRESS_ID
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      COUNTY
,      CITY
,      STATE
,      PROVINCE
,      ZIP_CODE
,      COUNTRY
,      ADDRESS_STYLE
,      TERRITORY_ID
,      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
,      TERRITORY_SHORT_NAME
,      CONCATENATED_ADDRESS
,      OFFICE_PARK_ID
,      OFFICE_PARK_NAME
,      REGION_ID
,      REGION_NAME
,      VACANT_AREA
,      LOAD_FACTOR
,      PRCT_VACANT
,      UTILIZED_CAPACITY
,      VACANCY
,      OCCUPANCY
,      AREA_UTILIZED
,      FLOORS
,      UNITS
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      OCCUPANCY_STATUS_CODE
,      OCCUPANCY_STATUS
,      ASSIGNABLE_EMP
,      ASSIGNABLE_CC
,      ASSIGNABLE_CUST
,      DISPOSITION_CODE
,      DISPOSITION
,      ACC_TREATMENT_CODE
,      ACC_TREATMENT
FROM APPS.PN_BUILDINGS_V;

Dependencies

[top of page]

APPS.PN_BUILDINGS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_TERRITORIES_VL; MTL_UNITS_OF_MEASURE; PNP_UTIL_FUNC - show dependent code; PN_ADDRESSES_ALL; PN_LOCATIONS; PN_LOCATION_PARKS; PN_PROPERTIES_ALL

APPS.PN_BUILDINGS_V is not referenced by any database object