[Home] [Help] [Dependency Information]
Object Name: | PN_LOCATIONS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | PN |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LOCATION_PARK_ID | NUMBER | |||
LOCATION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Yes | |
LOCATION_CODE | VARCHAR2 | (90) | Yes | |
LOCATION_ALIAS | VARCHAR2 | (30) | ||
BUILDING | VARCHAR2 | (50) | ||
LEASE_OR_OWNED | VARCHAR2 | (30) | ||
FLOOR | VARCHAR2 | (20) | ||
OFFICE | VARCHAR2 | (20) | ||
ADDRESS_ID | NUMBER | |||
MAX_CAPACITY | NUMBER | |||
OPTIMUM_CAPACITY | NUMBER | |||
RENTABLE_AREA | NUMBER | |||
USABLE_AREA | NUMBER | |||
ALLOCATE_COST_CENTER_CODE | VARCHAR2 | (30) | ||
UOM_CODE | VARCHAR2 | (3) | ||
DESCRIPTION | VARCHAR2 | (50) | ||
PARENT_LOCATION_ID | NUMBER | |||
INTERFACE_FLAG | VARCHAR2 | (1) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
STATUS | VARCHAR2 | (1) | Yes | |
SPACE_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ORG_ID | NUMBER | (15) | ||
SOURCE | VARCHAR2 | (80) | ||
PROPERTY_ID | NUMBER | |||
CLASS | VARCHAR2 | (30) | ||
STATUS_TYPE | VARCHAR2 | (30) | ||
SUITE | VARCHAR2 | (30) | ||
GROSS_AREA | NUMBER | |||
ASSIGNABLE_AREA | NUMBER | |||
COMMON_AREA | NUMBER | |||
COMMON_AREA_FLAG | VARCHAR2 | (1) | ||
FUNCTION_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
STANDARD_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
ACTIVE_START_DATE | DATE | Yes | ||
ACTIVE_END_DATE | DATE | Yes | ||
BOOKABLE_FLAG | VARCHAR2 | (1) | ||
OCCUPANCY_STATUS_CODE | VARCHAR2 | (30) | ||
ASSIGNABLE_EMP | VARCHAR2 | (30) | ||
ASSIGNABLE_CC | VARCHAR2 | (30) | ||
ASSIGNABLE_CUST | VARCHAR2 | (30) | ||
DISPOSITION_CODE | VARCHAR2 | (30) | ||
ACC_TREATMENT_CODE | VARCHAR2 | (30) |
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#;
|
|
|