[Home] [Help] [Dependency Information]
Object Name: | PN_LANDLORD_SERVICES_ALL |
---|---|
Object Type: | TABLE |
Owner: | PN |
FND Design Data: | PN.PN_LANDLORD_SERVICES_ALL |
Subobject Name: | |
Status: | VALID |
PN_LANDLORD_SERVICES_ALL stores information about the services provided by the landlord to the lessee, such as maintenance, security, and parking. There can be multiple rows based on the number of services provided by the landlord.
This table is partitioned by org.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PN_LANDLORD_SERVICES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LANDLORD_SERVICE_ID |
PN_LANDLORD_SERVICES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LEASE_ID
LEASE_CHANGE_ID |
PN_LANDLORD_SERVICES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | START_DATE |
PN_LANDLORD_SERVICES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LANDLORD_SERVICE_ID | NUMBER | Yes | Uniquely identifies a row for the services that are defined in a lease or in an amendement to the lease and are provided by the landlord. The value is populated using sequence PN_LANDLORD_SERVICES_S. | |
STATUS | VARCHAR2 | (1) | Yes | Indicates whether the service provided by the landlord is still active or not. Valid values: A - Active, I - Inactive |
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). | ||
LEASE_ID | NUMBER | Yes | Associates the lease row in PN_LEASES_ALL with the row in this table | |
LEASE_CHANGE_ID | NUMBER | Yes | Associates the row in PN_LEASE_CHANGES_ALL with the row in this table | |
SERVICE_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Yes | Identifies the type of service provided. The value is derived from the lookup_code in the FND_LOOKUPS table where lookup_type = PN_LANDLORD_SERVICE_TYPE. |
START_DATE | DATE | Start date of the service | ||
END_DATE | DATE | End date of the service | ||
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 | |
OBLIGATION_NUM | VARCHAR2 | (15) | Obligation Number. This is a system generated number without a database sequence generator, i.e, Select max(obligation_num)+1 from dual for a lease. | |
RESPONSIBILITY_CODE | VARCHAR2 | (30) | Type of Expense. A user-definable Quickcode | |
COMMON_AREA_RESP | VARCHAR2 | (30) | A type of area for an expense incurred in a multi-tenanted building that is attributable to all tenants | |
FINANCIAL_RESP_PARTY_CODE | VARCHAR2 | (30) | Determination of responsibility for an expense incurred by the company within the space it occupies | |
FINANCIAL_PCT_RESP | VARCHAR2 | (15) | If the responsible party is either landlord or tenant, the percent responsibility forexpenses is noted here if it is mentioned in the lease. | |
RESPONSIBILITY_MAINT | VARCHAR2 | (30) | Names the party responsible for performing the responsibility. | |
COMPANY_ID | NUMBER | Company ID of the Service Provider. List of values from the service provider. | ||
OBLIGATION_REFERENCE | VARCHAR2 | (15) | Paragraph in the original lease document that references the Obligation Responsibility | |
OBLIGATION_COMMENTS | VARCHAR2 | (2000) | Comments regarding theObligation responsibility. Comments should note language in the lease that is ambiguous, arbitrary or unusual such as pro-landlord or pro-tenant clauses |
Cut, paste (and edit) the following text to query this object:
SELECT LANDLORD_SERVICE_ID
, STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LEASE_ID
, LEASE_CHANGE_ID
, SERVICE_TYPE_LOOKUP_CODE
, START_DATE
, END_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, OBLIGATION_NUM
, RESPONSIBILITY_CODE
, COMMON_AREA_RESP
, FINANCIAL_RESP_PARTY_CODE
, FINANCIAL_PCT_RESP
, RESPONSIBILITY_MAINT
, COMPANY_ID
, OBLIGATION_REFERENCE
, OBLIGATION_COMMENTS
FROM PN.PN_LANDLORD_SERVICES_ALL;
PN.PN_LANDLORD_SERVICES_ALL does not reference any database object
PN.PN_LANDLORD_SERVICES_ALL is referenced by following:
|
|
|