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


VIEW: APPS.PN_VAR_TERMS_V

Object Details
Object Name: PN_VAR_TERMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPN.PN_VAR_TERMS_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
INVOICE_DATE DATE

VAR_RENT_INV_ID NUMBER

VAR_RENT_ID NUMBER
Yes
PERIOD_ID NUMBER

INCLUDE_TERM VARCHAR2 (4000)
INCLUDE_INCREASES VARCHAR2 (4000)
UPDATE_FLAG CHAR (1)
ROW_ID ROWID (10)
PAYMENT_TERM_ID NUMBER
Yes
LEASE_ID NUMBER
Yes
START_DATE DATE
Yes
END_DATE DATE
Yes
FREQUENCY_CODE VARCHAR2 (30) Yes
PAYMENT_PURPOSE VARCHAR2 (80) Yes
PAYMENT_TERM_TYPE VARCHAR2 (80) Yes
FREQUENCY_TYPE VARCHAR2 (80) Yes
VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
VENDOR_SITE VARCHAR2 (15)
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_NUMBER VARCHAR2 (30)
CUSTOMER_SITE_USE VARCHAR2 (40)
NORMALIZE VARCHAR2 (1)
ACTUAL_AMOUNT NUMBER

ESTIMATED_AMOUNT NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

ORG_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (15) Yes
Query Text

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


SELECT INVOICE_DATE
,      VAR_RENT_INV_ID
,      VAR_RENT_ID
,      PERIOD_ID
,      INCLUDE_TERM
,      INCLUDE_INCREASES
,      UPDATE_FLAG
,      ROW_ID
,      PAYMENT_TERM_ID
,      LEASE_ID
,      START_DATE
,      END_DATE
,      FREQUENCY_CODE
,      PAYMENT_PURPOSE
,      PAYMENT_TERM_TYPE
,      FREQUENCY_TYPE
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_SITE_USE
,      NORMALIZE
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      CURRENCY_CODE
FROM APPS.PN_VAR_TERMS_V;

Dependencies

[top of page]

APPS.PN_VAR_TERMS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_CUST_ACCOUNTS_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymPN_PAYMENT_TERMS_ALL
PL/SQL PackagePN_VAR_ABATEMENTS_PKG - show dependent code
SynonymPN_VAR_GRP_DATES_ALL
SynonymPN_VAR_PERIODS_ALL
SynonymPN_VAR_RENTS_ALL
SynonymPN_VAR_RENT_INV_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.PN_VAR_TERMS_V is not referenced by any database object