[Home] [Help] [Dependency Information]
Object Name: | PN_LOCATION_PARKS |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_LOCATION_PARKS |
Subobject Name: | |
Status: | VALID |
PN_LOCATION_PARKS stores information on Regions and Office Parks. A Region or an Office Park identifies the geographical grouping of a location. One or many office parks can be associated with a region via parent_location_park_id. An office park or a region can be used to group locations of type Building.
This table is multi-lingual and is not partitioned by Org.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_LOCATION_PARKS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
LOCATION_PARK_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_PARK_ID | NUMBER | Yes | Uniquely identifies a region or an office park row. The value is populated using sequence PN_LOCATION_PARKS_S | |
PARENT_LOCATION_PARK_ID | NUMBER | Associates the region with an office park row. The location_park_id of a region row is used to populate this data element. The value is null for a region row. | ||
NAME | VARCHAR2 | (50) | Yes | Name of a region or an office park |
DESCRIPTION | VARCHAR2 | (80) | Description of the region or office park | |
LOCATION_PARK_TYPE | VARCHAR2 | (30) | Yes | Identifies whether it is a region or an office park row. The value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_LOCATION_PARK_TYPE |
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). | |
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). | ||
LANGUAGE | VARCHAR2 | (4) | Yes | Stores the language code. |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Source language. Identifies the source which resulted in the creation of this row, for example, the language may be French but the row may have been created in a US English environment. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION_PARK_ID
, PARENT_LOCATION_PARK_ID
, NAME
, DESCRIPTION
, LOCATION_PARK_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM PN.PN_LOCATION_PARKS;
PN.PN_LOCATION_PARKS does not reference any database object
PN.PN_LOCATION_PARKS is referenced by following:
|
|
|