eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PN_VAR_RENT_DETAILS_V

Object Details

Object Name:	PN_VAR_RENT_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_VAR_RENT_DETAILS_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	(15)	Yes	Identifier of the variable rent agreement
CUMULATIVE_VOL	VARCHAR2	(1)		When checked indicates that volumes are considered cumulative for calculation of variable rent else non-cumulative.
PRORATION_RULE	VARCHAR2	(30)
PERIOD_ID	NUMBER	(15)	Yes
LINE_ITEM_ID	NUMBER	(15)	Yes
GROUP_DATE	DATE
INVOICE_DATE	DATE
GRP_DATE_ID	NUMBER	(15)	Yes
TRX_HEADER_ID	NUMBER	(15)	Yes
TRX_DETAIL_ID	NUMBER	(15)	Yes
CALC_PRD_START_DATE	DATE
CALC_PRD_END_DATE	DATE
DAYS	NUMBER
PRORATION_FACTOR	NUMBER
BKPT_VOL_START	NUMBER		Yes
BKPT_VOL_END	NUMBER
PRORATED_GRP_VOL_START	NUMBER
PRORATED_GRP_VOL_END	NUMBER
YTD_GROUP_VOL_START	NUMBER
YTD_GROUP_VOL_END	NUMBER
BLENDED_PERIOD_VOL_START	NUMBER
BLENDED_PERIOD_VOL_END	NUMBER
GROUP_SALES	NUMBER
GROUP_SALES_FOR	NUMBER
GROUP_DEDUCTIONS	NUMBER
NET_VOLUME	NUMBER
NET_VOLUME_FOR	NUMBER
CUMULATIVE_VOLUME	NUMBER
CUMULATIVE_VOLUME_FOR	NUMBER
OVERAGE	NUMBER
OVERAGE_FOR	NUMBER
BKPT_RATE	NUMBER		Yes
SEGMENT_VAR_RENT	NUMBER
SEGMENT_VAR_RENT_FOR	NUMBER
ACT_VAR_RENT	NUMBER
FOR_VAR_RENT	NUMBER
ACT_VAR_RENT_MIR	NUMBER
FOR_VAR_RENT_MIR	NUMBER
YTD_PERCENT_RENT	NUMBER
YTD_PERCENT_RENT_FOR	NUMBER
VAR_RENT_TYPE	VARCHAR2	(30)	Yes
IS_TRUE_UP	VARCHAR2	(4000)
ORG_ID	NUMBER	(15)		Organization identifier

Query Text

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


SELECT VAR_RENT_ID
,      CUMULATIVE_VOL
,      PRORATION_RULE
,      PERIOD_ID
,      LINE_ITEM_ID
,      GROUP_DATE
,      INVOICE_DATE
,      GRP_DATE_ID
,      TRX_HEADER_ID
,      TRX_DETAIL_ID
,      CALC_PRD_START_DATE
,      CALC_PRD_END_DATE
,      DAYS
,      PRORATION_FACTOR
,      BKPT_VOL_START
,      BKPT_VOL_END
,      PRORATED_GRP_VOL_START
,      PRORATED_GRP_VOL_END
,      YTD_GROUP_VOL_START
,      YTD_GROUP_VOL_END
,      BLENDED_PERIOD_VOL_START
,      BLENDED_PERIOD_VOL_END
,      GROUP_SALES
,      GROUP_SALES_FOR
,      GROUP_DEDUCTIONS
,      NET_VOLUME
,      NET_VOLUME_FOR
,      CUMULATIVE_VOLUME
,      CUMULATIVE_VOLUME_FOR
,      OVERAGE
,      OVERAGE_FOR
,      BKPT_RATE
,      SEGMENT_VAR_RENT
,      SEGMENT_VAR_RENT_FOR
,      ACT_VAR_RENT
,      FOR_VAR_RENT
,      ACT_VAR_RENT_MIR
,      FOR_VAR_RENT_MIR
,      YTD_PERCENT_RENT
,      YTD_PERCENT_RENT_FOR
,      VAR_RENT_TYPE
,      IS_TRUE_UP
,      ORG_ID
FROM APPS.PN_VAR_RENT_DETAILS_V;

Dependencies

[top of page]

APPS.PN_VAR_RENT_DETAILS_V references the following:

APPS: PN_VAR_BKPTS_DET_ALL; PN_VAR_GRP_DATES_ALL; PN_VAR_RENTS; PN_VAR_RENT_CALC_PKG - show dependent code; PN_VAR_TRX_DETAILS_ALL; PN_VAR_TRX_HEADERS_ALL

APPS.PN_VAR_RENT_DETAILS_V is not referenced by any database object