Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: PN.PN_SPACE_ASSIGN_LOC_ITF#

Object Details
Object Name: PN_SPACE_ASSIGN_LOC_ITF#
Object Type: VIEW
Owner: PN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER

LOCATION_TYPE VARCHAR2 (80)
LOCATION_NAME VARCHAR2 (30)
LOCATION_CODE VARCHAR2 (90)
SPACE_TYPE VARCHAR2 (80)
PROPERTY_CODE VARCHAR2 (90)
PROPERTY_NAME VARCHAR2 (30)
BUILDING_LOCATION_CODE VARCHAR2 (90)
BUILDING_OR_LAND_NAME VARCHAR2 (30)
FLOOR_LOCATION_CODE VARCHAR2 (90)
FLOOR_OR_PARCEL_NAME VARCHAR2 (30)
OFFICE_LOCATION_CODE VARCHAR2 (90)
OFFICE_OR_SECTION_NAME VARCHAR2 (30)
RENTABLE_AREA NUMBER

USABLE_AREA NUMBER

ASSIGNABLE_AREA NUMBER

COMMON_AREA NUMBER

PERSON_ID NUMBER

EMPLOYEE_NAME VARCHAR2 (240)
COST_CENTER VARCHAR2 (30)
EMPLOYEE_NUMBER VARCHAR2 (30)
EMPLOYEE_TYPE VARCHAR2 (80)
EMPLOYEE_CATEGORY VARCHAR2 (80)
EMPLOYEE_POSITION VARCHAR2 (80)
EMPLOYEE_PROJECT_NUMBER VARCHAR2 (25)
EMPLOYEE_TASK_NUMBER VARCHAR2 (20)
EMPLOYEE_ASSIGNED_AREA NUMBER

EMPLOYEE_VACANT_AREA NUMBER

EMPLOYEE_ASSIGNED_FROM DATE

EMPLOYEE_ASSIGNED_TO DATE

CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_SITE VARCHAR2 (40)
CUSTOMER_CATEGORY VARCHAR2 (80)
CUSTOMER_ACCOUNT VARCHAR2 (60)
CUSTOMER_PROJECT_NUMBER VARCHAR2 (25)
CUSTOMER_TASK_NUMBER VARCHAR2 (20)
CUSTOMER_ASSIGNED_AREA NUMBER

CUSTOMER_VACANT_AREA NUMBER

CUSTOMER_ASSIGNED_FROM DATE

CUSTOMER_ASSIGNED_TO DATE

LOC_ATTRIBUTE_CATEGORY VARCHAR2 (30)
LOC_ATTRIBUTE1 VARCHAR2 (150)
LOC_ATTRIBUTE2 VARCHAR2 (150)
LOC_ATTRIBUTE3 VARCHAR2 (150)
LOC_ATTRIBUTE4 VARCHAR2 (150)
LOC_ATTRIBUTE5 VARCHAR2 (150)
LOC_ATTRIBUTE6 VARCHAR2 (150)
LOC_ATTRIBUTE7 VARCHAR2 (150)
LOC_ATTRIBUTE8 VARCHAR2 (150)
LOC_ATTRIBUTE9 VARCHAR2 (150)
LOC_ATTRIBUTE10 VARCHAR2 (150)
LOC_ATTRIBUTE11 VARCHAR2 (150)
LOC_ATTRIBUTE12 VARCHAR2 (150)
LOC_ATTRIBUTE13 VARCHAR2 (150)
LOC_ATTRIBUTE14 VARCHAR2 (150)
LOC_ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER
Yes
Query Text

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


SELECT LOCATION_ID
,      LOCATION_TYPE
,      LOCATION_NAME
,      LOCATION_CODE
,      SPACE_TYPE
,      PROPERTY_CODE
,      PROPERTY_NAME
,      BUILDING_LOCATION_CODE
,      BUILDING_OR_LAND_NAME
,      FLOOR_LOCATION_CODE
,      FLOOR_OR_PARCEL_NAME
,      OFFICE_LOCATION_CODE
,      OFFICE_OR_SECTION_NAME
,      RENTABLE_AREA
,      USABLE_AREA
,      ASSIGNABLE_AREA
,      COMMON_AREA
,      PERSON_ID
,      EMPLOYEE_NAME
,      COST_CENTER
,      EMPLOYEE_NUMBER
,      EMPLOYEE_TYPE
,      EMPLOYEE_CATEGORY
,      EMPLOYEE_POSITION
,      EMPLOYEE_PROJECT_NUMBER
,      EMPLOYEE_TASK_NUMBER
,      EMPLOYEE_ASSIGNED_AREA
,      EMPLOYEE_VACANT_AREA
,      EMPLOYEE_ASSIGNED_FROM
,      EMPLOYEE_ASSIGNED_TO
,      CUSTOMER_NAME
,      CUSTOMER_SITE
,      CUSTOMER_CATEGORY
,      CUSTOMER_ACCOUNT
,      CUSTOMER_PROJECT_NUMBER
,      CUSTOMER_TASK_NUMBER
,      CUSTOMER_ASSIGNED_AREA
,      CUSTOMER_VACANT_AREA
,      CUSTOMER_ASSIGNED_FROM
,      CUSTOMER_ASSIGNED_TO
,      LOC_ATTRIBUTE_CATEGORY
,      LOC_ATTRIBUTE1
,      LOC_ATTRIBUTE2
,      LOC_ATTRIBUTE3
,      LOC_ATTRIBUTE4
,      LOC_ATTRIBUTE5
,      LOC_ATTRIBUTE6
,      LOC_ATTRIBUTE7
,      LOC_ATTRIBUTE8
,      LOC_ATTRIBUTE9
,      LOC_ATTRIBUTE10
,      LOC_ATTRIBUTE11
,      LOC_ATTRIBUTE12
,      LOC_ATTRIBUTE13
,      LOC_ATTRIBUTE14
,      LOC_ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
FROM PN.PN_SPACE_ASSIGN_LOC_ITF#;

Dependencies

[top of page]

PN.PN_SPACE_ASSIGN_LOC_ITF# references the following:

SchemaPN
TablePN_SPACE_ASSIGN_LOC_ITF
PN.PN_SPACE_ASSIGN_LOC_ITF# is referenced by following:

SchemaAPPS
SynonymPN_SPACE_ASSIGN_LOC_ITF