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_LOCATIONS_ITF

Object Details

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

The PN_LOCATIONS_ITF interface table stores the space definition data to be imported or exported into and out of Oracle Property Manager. The data elements pertain to the PN_LOCATIONS_ALL, PN_ADDRESSES_ALL, PN_CONTACTS_ALL, and PN_PHONES_ALL tables. 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.
This table is not partitioned by organization.
Scope: public
Product: PN
Lifecycle: active
Display Name: PN Locations Interface
Category: BUSINESS_ENTITY PN_PROPERTY

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_LOCATIONS_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LOCATION_ID
PN_LOCATIONS_ITF_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NAME	VARCHAR2	(30)	Yes	Name of batch. Required when importing data into Oracle Property Manager
ENTRY_TYPE	VARCHAR2	(1)	Yes	The type of row. A indicates creation of new location, U indicates modification of existing location, and R indicates replacement of existing location. Required when importing data into Oracle Property Manager
LOCATION_ID	NUMBER		Yes	Internal location identifier. Required when importing data into Oracle Property Manager
LOCATION_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Yes	Type of location. Derived from the LOOKUP_CODE in FND_LOOKUPS where the LOOKUP_TYPE matches the PN_LOCATION_TYPE. Required when importing data into Oracle Property Manager
LOCATION_CODE	VARCHAR2	(90)	Yes	Location Identifier. Oracle Property Manager generates this code based on a user-specified location alias. Required when importing data into Oracle Property Manager
LEASE_OR_OWNED	VARCHAR2	(30)		Indicator showing whether property is leased or owned
FLOOR	VARCHAR2	(20)		Name of the floor. Required when importing floor data into Oracle Property Manager
OFFICE	VARCHAR2	(20)		Name of the office. Required when importing office data into Oracle Property Manager
ADDRESS_LINE1	VARCHAR2	(240)		Address of the land or building
ADDRESS_LINE2	VARCHAR2	(240)		Address of the land or building
ADDRESS_LINE3	VARCHAR2	(240)		Address of the land or building
ADDRESS_LINE4	VARCHAR2	(240)		Address of the land or building
COUNTY	VARCHAR2	(60)		County where the building or land is located
CITY	VARCHAR2	(60)		City where the building or land is located
STATE	VARCHAR2	(60)		State where the building or land is located
PROVINCE	VARCHAR2	(60)		Province where the building or land is located
ZIP_CODE	VARCHAR2	(60)		Zip code for the building or land address
COUNTRY	VARCHAR2	(60)		Country where the building or land is located
ADDRESS_STYLE	VARCHAR2	(30)		Reserved for future use
MAX_CAPACITY	NUMBER			Maximum number of people the location can accommodate
OPTIMUM_CAPACITY	NUMBER			Optimum capacity of the location. Cannot be greater than location's maximum capacity
RENTABLE_AREA	NUMBER			Location's rentable area
USABLE_AREA	NUMBER			Location's usable area. Cannot be greater than location's rentable area
ALLOCATE_COST_CENTER_CODE	VARCHAR2	(30)		No longer used
UOM_CODE	VARCHAR2	(3)		Unit of measure used with the location. Validated using PN_UNITS_OF_MEASURE lookup when importing data into Oracle Property Manager
PARENT_LOCATION_ID	NUMBER			Identifier of the parent location. The value is null for building or land rows.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column: The date on which a user last updated the row
LAST_UPDATE_LOGIN	NUMBER			Standard Who column: The user who last updated the row. This column is a foreign key to FND_USER.USER_ID.
CREATED_BY	NUMBER			Standard Who column: The date on which the row was created
CREATION_DATE	DATE		Yes	Standard Who column: The user who created the row. This column is a foreign key to FND_USER.USER_ID.
LAST_UPDATED_BY	NUMBER			Standard Who column: The operating system login of user who last updated the row. This column is a foreign key to FND_LOGINS.LOGIN_ID.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Definition of the descriptive flexfield structure
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
ADDR_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Definition of the descriptive flexfield structure for the location's address
ADDR_ATTRIBUTE1	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE2	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE3	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE4	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE5	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE6	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE7	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE8	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE9	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE10	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE11	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE12	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE13	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE14	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
ADDR_ATTRIBUTE15	VARCHAR2	(150)		Address Descriptive Flexfield Segment column
TRANSFERRED_TO_CAD	VARCHAR2	(1)		Flag indicating whether the record has been exported to the external application (Y or N). Determines whether the row should be purged. Used only by Oracle Property Manager.
TRANSFERRED_TO_PN	VARCHAR2	(1)		Flag indicating whether the record has been imported into Oracle Property Manager (Y or N). Determines whether row should be purged. Used only by Oracle Property Manager.
ERROR_MESSAGE	VARCHAR2	(240)		Message error code if import or export of the record is unsuccessful
SOURCE	VARCHAR2	(80)		Name of the external application where the location originated
REQUEST_ID	NUMBER			Concurrent program Who column: The request Identifier of the program that last updated this row. This column is a foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID.
PROGRAM_APPLICATION_ID	NUMBER			Concurrent program Who column: The application Identifier of program that last updated this row. This column is a foreign key to FND_APPLICATION.APPLICATION_ID.
PROGRAM_ID	NUMBER			Concurrent program Who column: The identifier of the program that last updated this row. This column is a foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID.
PROGRAM_UPDATE_DATE	DATE			Concurrent program Who column: Date when the row was last updated
SPACE_TYPE_LOOKUP_CODE	VARCHAR2	(30)		The space type of the location. For example: mail room, office space, or rest room. Validated using PN_SPACE_TYPE LOOKUP_CODE in the FND_LOOKUPS table
GROSS_AREA	NUMBER			Gross area of a building or land
ASSIGNABLE_AREA	NUMBER			Assignable area of an office or section
CLASS	VARCHAR2	(30)		Identifier of the class of a building
STATUS_TYPE	VARCHAR2	(30)		Status of the location. For example, active or inactive
SUITE	VARCHAR2	(30)		Name of suite to which the office belongs
COMMON_AREA	NUMBER			Common space in the office or section
COMMON_AREA_FLAG	VARCHAR2	(30)		Flag indicating whether the location is designated as common area
FUNCTION_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Identifier of the location's function
LOCATION_ALIAS	VARCHAR2	(30)		Alias of the location. Oracle Property Manager uses the alias, along with the location code of the parent location, if any, to create the location code.
PROPERTY_ID	NUMBER			Identifier of the property
STANDARD_TYPE_LOOKUP_CODE	VARCHAR2	(30)		Identifier of the type of user using this space. For example, director or vice president
ACTIVE_START_DATE	DATE			Date from which location is active
ACTIVE_END_DATE	DATE			Date to which location is active
CHANGE_MODE	VARCHAR2	(30)		Flag indicating whether the location record should be corrected or updated
CHANGE_DATE	DATE			Date from which changes are effective
NEW_ACTIVE_START_DATE	DATE			Date when the location becomes active. Use this column to change a location's start date.
NEW_ACTIVE_END_DATE	DATE			Date from which this location becomes inactive. Use this column to change the location's end date.
SITE_ID	NUMBER	(15)		This column is used exclusively by Oracle Site Management (RSS). This column is not available to other users and does not affect functionality in any way.
BUILDING#1	VARCHAR2	(50)

Query Text

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


SELECT BATCH_NAME
,      ENTRY_TYPE
,      LOCATION_ID
,      LOCATION_TYPE_LOOKUP_CODE
,      LOCATION_CODE
,      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
,      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
,      TRANSFERRED_TO_CAD
,      TRANSFERRED_TO_PN
,      ERROR_MESSAGE
,      SOURCE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SPACE_TYPE_LOOKUP_CODE
,      GROSS_AREA
,      ASSIGNABLE_AREA
,      CLASS
,      STATUS_TYPE
,      SUITE
,      COMMON_AREA
,      COMMON_AREA_FLAG
,      FUNCTION_TYPE_LOOKUP_CODE
,      LOCATION_ALIAS
,      PROPERTY_ID
,      STANDARD_TYPE_LOOKUP_CODE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      CHANGE_MODE
,      CHANGE_DATE
,      NEW_ACTIVE_START_DATE
,      NEW_ACTIVE_END_DATE
,      SITE_ID
,      BUILDING#1
FROM PN.PN_LOCATIONS_ITF;

Dependencies

[top of page]

PN.PN_LOCATIONS_ITF does not reference any database object

PN.PN_LOCATIONS_ITF is referenced by following:

PN: PN_LOCATIONS_ITF#