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

VIEW: APPS.PN_FOR_RENT_DETAILS_V

Object Details
Object Name: PN_FOR_RENT_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPN.PN_FOR_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
GROUP_DATE DATE

Date derived from the variable rent dates table.Generated by the generate periods program.
INVOICE_DATE DATE

Date derived from the variable rent dates table. Generated by the generate periods program.
LINE_ITEM_ID NUMBER

Associates the summary row with a line items row in PN_VAR_LINES_ALL.
TOT_VOL NUMBER

Total forecasted volume on which variable rent calculation is based.
BKPT_VOL_START NUMBER

BKPT_VOL_END NUMBER

VOL_APPL NUMBER

BKPT_RATE NUMBER

VAR_RENT NUMBER

ACTUAL_EXP_CODE VARCHAR2 (1)
FORECASTED_EXP_CODE VARCHAR2 (1)
VARIANCE_EXP_CODE VARCHAR2 (1)
VAR_RENT_TYPE CHAR (10)
ORG_ID NUMBER (15)
Query Text

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


SELECT GROUP_DATE
,      INVOICE_DATE
,      LINE_ITEM_ID
,      TOT_VOL
,      BKPT_VOL_START
,      BKPT_VOL_END
,      VOL_APPL
,      BKPT_RATE
,      VAR_RENT
,      ACTUAL_EXP_CODE
,      FORECASTED_EXP_CODE
,      VARIANCE_EXP_CODE
,      VAR_RENT_TYPE
,      ORG_ID
FROM APPS.PN_FOR_RENT_DETAILS_V;

Dependencies

[top of page]

APPS.PN_FOR_RENT_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackagePN_VARIABLE_AMOUNT_PKG - show dependent code
SynonymPN_VAR_BKPTS_DET_ALL
SynonymPN_VAR_BKPTS_HEAD
SynonymPN_VAR_BKPTS_HEAD_ALL
SynonymPN_VAR_GRP_DATES_ALL
SynonymPN_VAR_PERIODS_ALL
SynonymPN_VAR_RENTS
SynonymPN_VAR_RENT_SUMM_ALL

APPS.PN_FOR_RENT_DETAILS_V is not referenced by any database object