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

VIEW: APPS.PN_VAR_RENT_SUMM_V

Object Details
Object Name: PN_VAR_RENT_SUMM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPN.PN_VAR_RENT_SUMM_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
VAR_RENT_ID NUMBER

PERIOD_ID NUMBER

LINE_ITEM_ID NUMBER

INVOICE_DATE DATE

ACTUAL_VOLUME NUMBER

FORECASTED_VOLUME NUMBER

CUMULATIVE_FOR_VOLUME NUMBER

DEDUCTIONS NUMBER

NET_ACTUAL_VOLUME NUMBER

CUMULATIVE_ACT_VOLUME NUMBER

ACT_VAR_RENT NUMBER

CUMULATIVE_ACT_RENT NUMBER

FOR_VAR_RENT NUMBER

CUMULATIVE_FOR_RENT NUMBER

INV_SCHEDULE_DATE DATE

INV_START_DATE DATE

INV_END_DATE DATE

ORG_ID NUMBER (15)
TRUEUP_VAR_RENT NUMBER

IS_TRUE_UP CHAR (1)
Query Text

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


SELECT VAR_RENT_ID
,      PERIOD_ID
,      LINE_ITEM_ID
,      INVOICE_DATE
,      ACTUAL_VOLUME
,      FORECASTED_VOLUME
,      CUMULATIVE_FOR_VOLUME
,      DEDUCTIONS
,      NET_ACTUAL_VOLUME
,      CUMULATIVE_ACT_VOLUME
,      ACT_VAR_RENT
,      CUMULATIVE_ACT_RENT
,      FOR_VAR_RENT
,      CUMULATIVE_FOR_RENT
,      INV_SCHEDULE_DATE
,      INV_START_DATE
,      INV_END_DATE
,      ORG_ID
,      TRUEUP_VAR_RENT
,      IS_TRUE_UP
FROM APPS.PN_VAR_RENT_SUMM_V;

Dependencies

[top of page]

APPS.PN_VAR_RENT_SUMM_V references the following:

SchemaAPPS
SynonymPN_VAR_PERIODS_ALL
PL/SQL PackagePN_VAR_RENT_CALC_PKG - show dependent code
SynonymPN_VAR_RENT_SUMM
SynonymPN_VAR_RENT_SUMM_ALL

APPS.PN_VAR_RENT_SUMM_V is not referenced by any database object