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

TABLE: PN.PN_REC_PERIOD_LINES_ALL

Object Details
Object Name: PN_REC_PERIOD_LINES_ALL
Object Type: TABLE
Owner: PN
FND Design Data: TablePN.PN_REC_PERIOD_LINES_ALL
Subobject Name:
Status: VALID


Table stores information about calculated recovery amounts for a line for a calculation period


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PN_REC_PERIOD_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_PERIOD_LINES_ID
PN_REC_PERIOD_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_AGR_LINE_ID
PN_REC_PERIOD_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_CALC_PERIOD_ID
PN_REC_PERIOD_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE
PN_REC_PERIOD_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_DATE
PN_REC_PERIOD_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAS_OF_DATE
Columns
Name Datatype Length Mandatory Comments
REC_PERIOD_LINES_ID NUMBER (15) Yes Uniquely identifies the period-lines row. This is the primary key for the table.
REC_CALC_PERIOD_ID NUMBER (15) Yes Associates the period lines row with a calculation period row in PN_REC_CALC_PERIOD_ALL table
REC_AGR_LINE_ID NUMBER (15)
Associates the period lines row with a recovery period row in PN_REC_CALC_PERIODS_ALL table
AS_OF_DATE DATE

As of date of the calc. period
START_DATE DATE

Start date of the calc. period
END_DATE DATE

End date of the calc. period
BILLING_TYPE VARCHAR2 (30)
Billing type associated with the line
BILLING_PURPOSE VARCHAR2 (30)
Billing purpose associated with the line
CUST_ACCOUNT_ID NUMBER (15)
Associates the period lines row with a customer space assignment row in PN_SPACE_ASSIGN_CUST_ALL
LAST_UPDATE_DATE DATE
Yes Standard who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column.
CREATION_DATE DATE
Yes Standard who column.
CREATED_BY NUMBER (15) Yes Standard who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column.
TOTAL_AREA NUMBER

Total area of the property used for calculation of recovery for the line
TOTAL_EXPENSE NUMBER

Total expense used for calculation of recovery for the line
RECOVERABLE_AREA NUMBER

Recoverable area of the location used for calculation of recovery for the line
ACTUAL_RECOVERY NUMBER

Actual recovery amount calculated
CONSTRAINED_ACTUAL NUMBER

Recovery Amount after applying constraints
ABATEMENTS NUMBER

Total abatements applied to the recovery amount
ACTUAL_PRORATA_SHARE NUMBER

Prorata share of Recovery Amount after applying abatements to constrained actual
BILLED_RECOVERY NUMBER

Recoverable amount that has been billed
RECONCILED_AMOUNT NUMBER

Recovery amount after applying billed recovery to the actual prorata share
BUDGET_RECOVERY NUMBER

Recovery amount as budgeted
BUDGET_EXPENSE NUMBER

Expense amount as budgeted
BUDGET_PRORATA_SHARE NUMBER

Prorata share of recovery amount as budgeted
BUDGET_COST_PER_AREA NUMBER

Cost per area as budgeted
BUDGET_PCT NUMBER

Budget percentage
OCCUPANCY_PCT NUMBER

Occupancy percentage
MULTIPLE_PCT NUMBER

Multiple percentage as entered for each line in PNREC_AGR_LINES_ALL
TENANCY_START_DATE DATE

Start date of tenancy
TENANCY_END_DATE DATE

End date of tenancy
STATUS VARCHAR2 (30)
Based on the result of calculation the values are ERROR,COMPLETE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield.
ORG_ID NUMBER (15)
Operating unit identifier.
FIXED_PCT NUMBER

The percentage value associated with a recovery line having calculation method of Fixed Percentage
Query Text

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


SELECT REC_PERIOD_LINES_ID
,      REC_CALC_PERIOD_ID
,      REC_AGR_LINE_ID
,      AS_OF_DATE
,      START_DATE
,      END_DATE
,      BILLING_TYPE
,      BILLING_PURPOSE
,      CUST_ACCOUNT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TOTAL_AREA
,      TOTAL_EXPENSE
,      RECOVERABLE_AREA
,      ACTUAL_RECOVERY
,      CONSTRAINED_ACTUAL
,      ABATEMENTS
,      ACTUAL_PRORATA_SHARE
,      BILLED_RECOVERY
,      RECONCILED_AMOUNT
,      BUDGET_RECOVERY
,      BUDGET_EXPENSE
,      BUDGET_PRORATA_SHARE
,      BUDGET_COST_PER_AREA
,      BUDGET_PCT
,      OCCUPANCY_PCT
,      MULTIPLE_PCT
,      TENANCY_START_DATE
,      TENANCY_END_DATE
,      STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      FIXED_PCT
FROM PN.PN_REC_PERIOD_LINES_ALL;

Dependencies

[top of page]

PN.PN_REC_PERIOD_LINES_ALL does not reference any database object

PN.PN_REC_PERIOD_LINES_ALL is referenced by following:

SchemaPN
ViewPN_REC_PERIOD_LINES_ALL#