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_OFFICES_V

Object Details

Object Name:	PN_OFFICES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_OFFICES_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)
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_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
SPACE_TYPE	VARCHAR2	(80)		This captures the meaning from the FND_LOOKUPS table where lookup_type = PN_SPACE_TYPE
FUNCTION_TYPE_LOOKUP_CODE	VARCHAR2	(30)
FUNCTION_TYPE	VARCHAR2	(80)
STANDARD_TYPE_LOOKUP_CODE	VARCHAR2	(30)
STANDARD_TYPE	VARCHAR2	(80)
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	(30)		null
FLOOR	VARCHAR2	(20)		null
OFFICE	VARCHAR2	(20)		Name of an office . This data elemet is null for a building and floor row
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 greate than rentable area
ASSIGNABLE_AREA	NUMBER			Assignable area of this location Assignable area cannot be greater than the usable area
COMMON_AREA	NUMBER			Common area of this location Common area cannot be greater than the usable area
SUITE	VARCHAR2	(30)		Name of the Suite
PARENT_LOCATION_ID	NUMBER			This will capture the parent location id for any office location id
BUILDING_ID	NUMBER			This will capture the Building ID
STATUS	VARCHAR2	(1)	Yes	This captures the status of the location as Active or Inactive
INTERFACE_FLAG	VARCHAR2	(1)		To be used later
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment column.
VACANT_AREA	NUMBER			This is a computed column
UTILIZED_CAPACITY	NUMBER			This is a computed column
VACANCY	NUMBER			This is a computed column
SECONDARY_CIRCULATION	NUMBER			This is a computed column
COMMON_AREA_FLAG	VARCHAR2	(1)		Identifies whether the space is for common usage or not. Valid values: Y - Yes , Null or N - No
ACTIVE_START_DATE	DATE		Yes
ACTIVE_END_DATE	DATE
BOOKABLE_FLAG	VARCHAR2	(1)		Indicates whether or not a location can be booked.
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
,      LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LOCATION_TYPE_LOOKUP_CODE
,      LOCATION_TYPE
,      SPACE_TYPE_LOOKUP_CODE
,      SPACE_TYPE
,      FUNCTION_TYPE_LOOKUP_CODE
,      FUNCTION_TYPE
,      STANDARD_TYPE_LOOKUP_CODE
,      STANDARD_TYPE
,      LOCATION_CODE
,      LOCATION_ALIAS
,      BUILDING
,      FLOOR
,      OFFICE
,      MAX_CAPACITY
,      OPTIMUM_CAPACITY
,      RENTABLE_AREA
,      USABLE_AREA
,      ASSIGNABLE_AREA
,      COMMON_AREA
,      SUITE
,      PARENT_LOCATION_ID
,      BUILDING_ID
,      STATUS
,      INTERFACE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VACANT_AREA
,      UTILIZED_CAPACITY
,      VACANCY
,      SECONDARY_CIRCULATION
,      COMMON_AREA_FLAG
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      BOOKABLE_FLAG
,      OCCUPANCY_STATUS_CODE
,      OCCUPANCY_STATUS
,      ASSIGNABLE_EMP
,      ASSIGNABLE_CC
,      ASSIGNABLE_CUST
,      DISPOSITION_CODE
,      DISPOSITION
,      ACC_TREATMENT_CODE
,      ACC_TREATMENT
FROM APPS.PN_OFFICES_V;

Dependencies

[top of page]

APPS.PN_OFFICES_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; PNP_UTIL_FUNC - show dependent code; PN_LOCATIONS; PN_LOCATIONS_ALL

APPS.PN_OFFICES_V is not referenced by any database object