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_FLOORS_V

Object Details

Object Name:	PN_FLOORS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_FLOORS_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 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
FUNCTION_TYPE	VARCHAR2	(80)		This captures the meaning from 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
STANDARD_TYPE	VARCHAR2	(80)		This captures the meaning from 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)		null
FLOOR	VARCHAR2	(20)		Name of a floor. This data elemet is null for a building and office row
PARENT_LOCATION_ID	NUMBER			This will capture the parent location id for any floor location 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
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
,      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
,      PARENT_LOCATION_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
,      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_FLOORS_V;

Dependencies

[top of page]

APPS.PN_FLOORS_V references the following:

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

APPS.PN_FLOORS_V is not referenced by any database object