[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PN_LOCATIONS_PUB_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PN.PN_LOCATIONS_PUB_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Identifies a location and its attributes
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Identifier | |
| LOCATION_ID | NUMBER | Yes | Internal Location Identifier | |
| LOCATION_CODE | VARCHAR2 | (90) | Yes | Location Identifier. Oracle Property Manager generates this code based on the user-specified location alias. |
| LOCATION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Yes | Code for location type. Value is derived from the LOOKUP_CODE in the FND_LOOKUPS table where the LOOKUP_TYPE matches the PN_LOCATION_TYPE |
| ACTIVE_START_DATE | DATE | Yes | Date from which the location is defined. Column is used for tracking location dates and forms part of the primary key for this table along with LOCATION_ID and ACTIVE_END_DATE. | |
| ACTIVE_END_DATE | DATE | Yes | Date to which this location is defined. Column is used for tracking location dates and forms part of the primary key for this table along with LOCATION_ID and ACTIVE_START_DATE. | |
| LOCATION_ALIAS | VARCHAR2 | (30) | Used to create a location code | |
| PARENT_LOCATION_CODE | VARCHAR2 | (90) | Location Code of the parent location. This data element is null for a building or land row. | |
| GPARENT_LOCATION_CODE | VARCHAR2 | (90) | The Location Code of the parent locations parent | |
| LOCATION_NAME | VARCHAR2 | (50) | Name of the location | |
| PARENT_LOCATION_NAME | VARCHAR2 | (50) | Name of the parent locations parent | |
| GPARENT_LOCATION_NAME | VARCHAR2 | (50) | Name of the parent locations parent | |
| SUITE | VARCHAR2 | (30) | Suite to which the office is attached | |
| UOM_CODE | VARCHAR2 | (3) | Unit of measure used to calculate the area of the location. Derived from the lookup_code column in FND_LOOKUPS where LOOKUP_TYPE matches the PN_UNITS_OF_MEASURE | |
| SPACE_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | TCode representing the locations space type | |
| SPACE_TYPE | VARCHAR2 | (80) | Purpose for which the location is used, for example, as workspace, storage space, or training room | |
| FUNCTION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Code representing the locations function type | |
| FUNCTION_TYPE | VARCHAR2 | (80) | Function of the location, for example, whether the location is an office or workstation, kitchen, or library | |
| STANDARD_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Code representing the locations standard type | |
| STANDARD_TYPE | VARCHAR2 | (80) | Type of individual who uses the location, for example, contractor, manager, or vice president | |
| STATUS_TYPE | VARCHAR2 | (30) | Code representing the locations status type | |
| STATUS_TYPE_NAME | VARCHAR2 | (80) | Status of the location, for example, whether it is condemned, under construction, or operational | |
| MAX_CAPACITY | NUMBER | Maximum number of people a location can hold | ||
| OPTIMUM_CAPACITY | NUMBER | Optimum capacity for the location. Cannot be greater than the locations maximum capacity | ||
| RENTABLE_AREA | NUMBER | The locations rentable area | ||
| USABLE_AREA | NUMBER | The locations usable area. Cannot be greater than rentable area | ||
| GROSS_AREA | NUMBER | The locations usable area. Cannot be greater than rentable area | ||
| ASSIGNABLE_AREA | NUMBER | Assignable area of an office or section | ||
| COMMON_AREA | NUMBER | Common area of an office or section | ||
| VACANT_AREA | NUMBER | Calculated data element that indicates the vacant area at a location | ||
| VACANT_AREA_PERCENT | NUMBER | Calculated data element that indicates the percentage of vacant area at a location | ||
| LEVELS | NUMBER | Calculated data element that indicates the number of floors in a building or offices on a floor | ||
| UNITS | NUMBER | Calculated data element that indicates the number of offices on a floor | ||
| UTILIZED_CAPACITY | NUMBER | Calculated data element that indicates the locations utilized capacity | ||
| LOAD_FACTOR | NUMBER | Calculated data element that indicates the load factor of the location | ||
| UTILIZED_AREA | NUMBER | Calculated data element that indicates the locations utilized area | ||
| VACANCY | NUMBER | Number of vacancies at the location | ||
| SECONDARY_CIRCULATION | NUMBER | Calculated data element. Derived by subtracting common and assignable area from a locations usable area. | ||
| COMMON_AREA_FLAG | VARCHAR2 | (1) | Flag to indicate whether the space is meant for common use | |
| PROPERTY_ID | NUMBER | Internal Identifier of the property on which the building is located | ||
| PROPERTY_NAME | VARCHAR2 | (30) | Name of the property on which the building is located | |
| PROPERTY_CODE | VARCHAR2 | (90) | The code of the property on which the building is located | |
| TENURE_CODE | VARCHAR2 | (30) | The TENURE_CODE for the building | |
| TENURE | VARCHAR2 | (80) | Tenure of the building, for example, leased, owned, mixed, or managed. | |
| CLASS | VARCHAR2 | (30) | The class code for the building. | |
| CLASS_MEANING | VARCHAR2 | (80) | Class of the building, for example, urban or rural | |
| STATUS | VARCHAR2 | (1) | Yes | Status of the location, for example, active or inactive |
| PARENT_STATUS | VARCHAR2 | (1) | Yes | Status of the parent location |
| GPARENT_STATUS | VARCHAR2 | (1) | Yes | Status of the parent locations parent |
| 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) | Yes | Country where the building or land is located |
| TERRITORY_ID | NUMBER | Territory ID for address of the land or building | ||
| ADDR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Definition of the Descriptive Flexfield structure for the locations address | |
| ADDR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ADDR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| TERRITORY_SHORT_NAME | VARCHAR2 | (80) | Yes | Name of the territory to which the building or land belongs |
| OFFICE_PARK | VARCHAR2 | (50) | Office park to which the building or land belongs | |
| REGION | VARCHAR2 | (50) | Region to which the building or land belongs | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column. The date on which a user last updated the row | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column. User who last updated the row. Foreign key to FND_USER.USER_ID | |
| CREATION_DATE | DATE | Yes | Standard Who column. Date on which the row was created | |
| CREATED_BY | NUMBER | Yes | Standard Who column. User who created the row. Foreign key to FND_USER.USER_ID | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column: Operating system login of user who last updated the row. Foreign key to FND_LOGINS.LOGIN_ID | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | The 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 | |
| ORG_ID | NUMBER | (15) | Organization Identifier | |
| BOOKABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether a location can be reserved | |
| OCCUPANCY_STATUS_CODE | VARCHAR2 | (30) | The occupancy status of a location. It can be Y (occupiable) or N (not occupiable) | |
| OCCUPANCY_STATUS | VARCHAR2 | (80) | This captures the meaning of the occupancy status code from fnd_lookups where the lookup type is PN_OCCUPANCY_STATUS_CODE | |
| 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) | This captures the meaning of the disposition code from fnd_lookups where the lookup type is PN_DISPOSITION_CODE | |
| DISPOSITION | VARCHAR2 | (80) | This captures the meaning of the disposition code from fnd_lookups where the lookup type is PN_DISPOSITION_CODE | |
| ACC_TREATMENT_CODE | VARCHAR2 | (30) | Indicates the accounting treatment of a location | |
| ACC_TREATMENT | VARCHAR2 | (80) | This captures the meaning of the accounting treatment code from fnd_lookups where the lookup type is PN_ACC_TREATMENT_CODE |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LOCATION_ID
, LOCATION_CODE
, LOCATION_TYPE_LOOKUP_CODE
, ACTIVE_START_DATE
, ACTIVE_END_DATE
, LOCATION_ALIAS
, PARENT_LOCATION_CODE
, GPARENT_LOCATION_CODE
, LOCATION_NAME
, PARENT_LOCATION_NAME
, GPARENT_LOCATION_NAME
, SUITE
, UOM_CODE
, SPACE_TYPE_LOOKUP_CODE
, SPACE_TYPE
, FUNCTION_TYPE_LOOKUP_CODE
, FUNCTION_TYPE
, STANDARD_TYPE_LOOKUP_CODE
, STANDARD_TYPE
, STATUS_TYPE
, STATUS_TYPE_NAME
, MAX_CAPACITY
, OPTIMUM_CAPACITY
, RENTABLE_AREA
, USABLE_AREA
, GROSS_AREA
, ASSIGNABLE_AREA
, COMMON_AREA
, VACANT_AREA
, VACANT_AREA_PERCENT
, LEVELS
, UNITS
, UTILIZED_CAPACITY
, LOAD_FACTOR
, UTILIZED_AREA
, VACANCY
, SECONDARY_CIRCULATION
, COMMON_AREA_FLAG
, PROPERTY_ID
, PROPERTY_NAME
, PROPERTY_CODE
, TENURE_CODE
, TENURE
, CLASS
, CLASS_MEANING
, STATUS
, PARENT_STATUS
, GPARENT_STATUS
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, ADDRESS_LINE4
, COUNTY
, CITY
, STATE
, PROVINCE
, ZIP_CODE
, COUNTRY
, TERRITORY_ID
, 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
, TERRITORY_SHORT_NAME
, OFFICE_PARK
, REGION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, BOOKABLE_FLAG
, OCCUPANCY_STATUS_CODE
, OCCUPANCY_STATUS
, ASSIGNABLE_EMP
, ASSIGNABLE_CC
, ASSIGNABLE_CUST
, DISPOSITION_CODE
, DISPOSITION
, ACC_TREATMENT_CODE
, ACC_TREATMENT
FROM APPS.PN_LOCATIONS_PUB_V;
APPS
FND_GLOBAL
- show dependent code
FND_LOOKUPS
FND_TERRITORIES_VL
PNP_UTIL_FUNC
- show dependent code
PN_ADDRESSES_ALL
PN_LOCATIONS_ALL
PN_LOCATION_PARKS
PN_PROPERTIES_ALL
APPS.PN_LOCATIONS_PUB_V is not referenced by any database object
|
|
|
|