[Home] [Help] [Dependency Information]
Object Name: | PN_LOCATIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_LOCATIONS_ALL |
Subobject Name: | |
Status: | VALID |
PN_LOCATIONS_ALL stores space definition information. The space can be defined as a building, a floor, or an office. The floor is linked to the building, and the office is linked to the floor, by means of parent_location_id.
Note: The address information in this table is only linked to a building record
The table is partitioned by org.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_LOCATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LOCATION_ID
ACTIVE_START_DATE ACTIVE_END_DATE |
PN_LOCATIONS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LOCATION_CODE
LOCATION_TYPE_LOOKUP_CODE ACTIVE_START_DATE ACTIVE_END_DATE |
PN_LOCATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_PARK_ID |
PN_LOCATIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUILDING |
PN_LOCATIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FLOOR |
PN_LOCATIONS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OFFICE |
PN_LOCATIONS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARENT_LOCATION_ID |
PN_LOCATIONS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COMMON_AREA_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_ID | NUMBER | Yes | Uniquely identifies a location row. The value is populated using sequence PN_LOCATIONS_S | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LOCATION_PARK_ID | NUMBER | Associates the row in PN_LOCATION_PARKS with the locations row | ||
LOCATION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Yes | Type of location, such as building, floor, office, etc. The value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_LOCATION_TYPE |
LOCATION_CODE | VARCHAR2 | (90) | Yes | Another way of uniquely identifying a location. The locations are classified as: BUILDING, FLOOR and OFFICE. Oracle Property Manager generates this unique code based on the input provided by the user in the location_alias data element. If the location_alias for the building row is 3OP, the location code for the building is created as 3OP. For a floor in the same building, if the location_alias is -02 then the floor's location code is created as 3OP-2. For an office on the same floor, if the location_alias is -201 then the office location code is created as 3OP-02-201. |
LOCATION_ALIAS | VARCHAR2 | (30) | This data element is used to create the location code for a building, floor and office. | |
BUILDING | VARCHAR2 | (30) | Name of the building. This data element is null for a floor and an office row | |
LEASE_OR_OWNED | VARCHAR2 | (30) | Identifies whether the property is leased or owned or mixed or managed. Valid values : L------ Leased, MG------ Managed, MI------ Mixed, O------ Owned | |
FLOOR | VARCHAR2 | (20) | Name of the floor, for example, 'First Floor' or '01'. This data element is null for a building and an office row. | |
OFFICE | VARCHAR2 | (20) | Name of the office, for example, ' CEO's Office' or '01'. This data element is null for a floor and building row. | |
ADDRESS_ID | NUMBER | Associates the row in PN_ADDRESSES_ALL with the location. This data element is null for a floor and an office row. The address is defined for a building row only | ||
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 greater than rentable area. | ||
ALLOCATE_COST_CENTER_CODE | VARCHAR2 | (30) | The cost center to which this location is allocated | |
UOM_CODE | VARCHAR2 | (3) | The unit of measure used to calculate the area of this location. The value is derived from the lookup_code column in FND_LOOKUPS where lookup_type = PN_UNITS_OF_MEASURE | |
DESCRIPTION | VARCHAR2 | (50) | Obsolete. To be deleted. | |
PARENT_LOCATION_ID | NUMBER | Identifies the parent location. The data element is null for a building row. The location_id of the building row is populated for the floor row within the building. The location id of the floor row is populated for an office row within the floor. | ||
INTERFACE_FLAG | VARCHAR2 | (1) | To be used later | |
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). | ||
STATUS | VARCHAR2 | (1) | Yes | Identifies the status of the location. Valid values: A - Active, I - Inactive |
SPACE_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Identifies the type of space, for example Mail Room, Office Space, Rest Rooms, etc. The value is derived from the lookup_code in FND_LOOKUPS table where lookup_type = PN_SPACE_TYPE | |
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 | |
ORG_ID | NUMBER | (15) | Organization identifier | |
SOURCE | VARCHAR2 | (80) | Name of the external application which created the locations row in Oracle Property Manager. | |
PROPERTY_ID | NUMBER | Property ID of the Property. List of values from the Property. | ||
CLASS | VARCHAR2 | (30) | Class Name. List of values available. | |
STATUS_TYPE | VARCHAR2 | (30) | Status Type Name. List of values available. | |
SUITE | VARCHAR2 | (30) | A Suite can have Offices attached to it. | |
GROSS_AREA | NUMBER | Gross Area to be defined at the Building/Land Level. | ||
ASSIGNABLE_AREA | NUMBER | Assignable Area to be defined at the Office/Section Level. | ||
COMMON_AREA | NUMBER | Common Area to be defined at the Office/Section Level. | ||
COMMON_AREA_FLAG | VARCHAR2 | (1) | Identifies whether the space is for common usage or not. | |
FUNCTION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Type of Space, such as Mail Room , Office Space etc. | |
STANDARD_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Type of Space, such as Mail Room , Office Space etc. | |
ACTIVE_START_DATE | DATE | Yes | The date from which this location is active. This column is for locations date tracking and forms part of the primary key for this table along with the Location_ID and Active_End_Date columns | |
ACTIVE_END_DATE | DATE | Yes | The date up to which this location is active. This column is for locations date tracking and forms part of the primary key for this table along with the Location_ID and Active_Start_Date columns | |
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). | |
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. | |
ACC_TREATMENT_CODE | VARCHAR2 | (30) | Indicates the Accounting Treatment of a location. |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LOCATION_PARK_ID
, LOCATION_TYPE_LOOKUP_CODE
, LOCATION_CODE
, LOCATION_ALIAS
, BUILDING
, LEASE_OR_OWNED
, FLOOR
, OFFICE
, ADDRESS_ID
, MAX_CAPACITY
, OPTIMUM_CAPACITY
, RENTABLE_AREA
, USABLE_AREA
, ALLOCATE_COST_CENTER_CODE
, UOM_CODE
, DESCRIPTION
, PARENT_LOCATION_ID
, INTERFACE_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, STATUS
, SPACE_TYPE_LOOKUP_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, SOURCE
, PROPERTY_ID
, CLASS
, STATUS_TYPE
, SUITE
, GROSS_AREA
, ASSIGNABLE_AREA
, COMMON_AREA
, COMMON_AREA_FLAG
, FUNCTION_TYPE_LOOKUP_CODE
, STANDARD_TYPE_LOOKUP_CODE
, ACTIVE_START_DATE
, ACTIVE_END_DATE
, BOOKABLE_FLAG
, OCCUPANCY_STATUS_CODE
, ASSIGNABLE_EMP
, ASSIGNABLE_CC
, ASSIGNABLE_CUST
, DISPOSITION_CODE
, ACC_TREATMENT_CODE
FROM PN.PN_LOCATIONS_ALL;
PN.PN_LOCATIONS_ALL does not reference any database object
PN.PN_LOCATIONS_ALL is referenced by following:
|
|
|