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]

TABLE: PN.PN_SPACE_ALLOC_ITF

Object Details

Object Name:	PN_SPACE_ALLOC_ITF
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_SPACE_ALLOC_ITF
Subobject Name:
Status:	VALID

No Longer Used
The PN_SPACE_ALLOC_ITF interface table stores the space assignment definition data to be imported or exported into and out of Oracle Property Manager. The data elements pertain to the PN_SPACE_ALLOCATIONS_ALL table. This table is a gateway between the third party software and Oracle Property Manager. The data is created and extracted using export and import programs from both sets of applications.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_SPACE_ALLOC_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SPACE_ALLOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NAME	VARCHAR2	(30)	Yes	Name of the batch. The value is required when importing data into Oracle Property Manager
ENTRY_TYPE	VARCHAR2	(1)	Yes	Row type. Valid values: A - Add (Create a new space allocation row), U - Update (Modify an existing space allocation row), D - Delete (Delete an existing space allocation row). The value is required when importing data into Oracle Property Manager
SPACE_ALLOCATION_ID	NUMBER			Space_Allocation_ID is a unique identifier generated from an Oracle database sequence. This data element is mapped to the space_allocation_id in PN_SPACE_ALLOCATIONS_ALL. The value is required when importing data into Oracle Property Manager
LOCATION_ID	NUMBER			Associates a location with an employee, contractor or cost center. This data element is mapped to the location_id in PN_SPACE_ALLOCATIONS_ALL. The value is required when importing data into Oracle Property Manager.
EMPLOYEE_ID	NUMBER			Uniquely identifies an employee. This data element is mapped to the employee_id in PN_SPACE_ALLOCATIONS_ALL. The value is optional.
COST_CENTER_CODE	VARCHAR2	(30)		Cost center to which this space must be charged. This data element is mapped to the cost_center_code in PN_SPACE_ALLOCATIONS_ALL. Optional.
ALLOCATED_AREA	NUMBER			Allocated area for the space. Calculated value: (USEABLE_AREA / total number of space assignments to a location) . This data element is mapped to allocated_area_pct in PN_SPACE_ALLOCATIONS_ALL. The value is required when importing data into Oracle Property Manager.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
TRANSFERRED_TO_CAD	VARCHAR2	(1)		Identify whether the transaction has been exported to external application. Valid values: Y - The data is transferred, N - Not transferred. This data element is for Oracle Property Manager's usage only. It will also be used to purge data from the table.
TRANSFERRED_TO_PN	VARCHAR2	(1)		Identify whether the transaction has been imported into Oracle Property Manager. Valid values: Y - Imported, N - Not imported. The data element is for Oracle Property Manager's usage only. It will also be used to purge data from this table.
ERROR_MESSAGE	VARCHAR2	(240)		Error message code. Transaction which failed to export or import will have a value.
SOURCE	VARCHAR2	(80)		The name of the external application which created the transaction.
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ALLOCATED_PERCENTAGE	NUMBER			Allocated percentage for the space. The value is required

Query Text

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


SELECT BATCH_NAME
,      ENTRY_TYPE
,      SPACE_ALLOCATION_ID
,      LOCATION_ID
,      EMPLOYEE_ID
,      COST_CENTER_CODE
,      ALLOCATED_AREA
,      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
,      TRANSFERRED_TO_CAD
,      TRANSFERRED_TO_PN
,      ERROR_MESSAGE
,      SOURCE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ALLOCATED_PERCENTAGE
FROM PN.PN_SPACE_ALLOC_ITF;

Dependencies

[top of page]

PN.PN_SPACE_ALLOC_ITF does not reference any database object

PN.PN_SPACE_ALLOC_ITF is referenced by following:

APPS: PN_SPACE_ALLOC_ITF