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

VIEW: APPS.PN_INDEX_EXCLUDE_TERM_V

Object Details
Object Name: PN_INDEX_EXCLUDE_TERM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPN.PN_INDEX_EXCLUDE_TERM_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
INDEX_LEASE_ID NUMBER
Yes Uniquely identifies the Rent Increase row. The value is populated using the sequence PN_INDEX_LEASES_S.
PAYMENT_TERM_ID NUMBER

EXCLUDE_FLAG VARCHAR2 (1)
PAYMENT_PURPOSE VARCHAR2 (80)
PAYMENT_TERM_TYPE VARCHAR2 (80)
PAYMENT_TERM_TYPE_CODE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

ACTUAL_AMOUNT NUMBER

VENDOR_NUMBER VARCHAR2 (30)
VENDOR_NAME VARCHAR2 (240)
CUSTOMER_NUMBER VARCHAR2 (30)
CUSTOMER_NAME VARCHAR2 (360)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

ORG_ID NUMBER

Query Text

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


SELECT INDEX_LEASE_ID
,      PAYMENT_TERM_ID
,      EXCLUDE_FLAG
,      PAYMENT_PURPOSE
,      PAYMENT_TERM_TYPE
,      PAYMENT_TERM_TYPE_CODE
,      START_DATE
,      END_DATE
,      ACTUAL_AMOUNT
,      VENDOR_NUMBER
,      VENDOR_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM APPS.PN_INDEX_EXCLUDE_TERM_V;

Dependencies

[top of page]

APPS.PN_INDEX_EXCLUDE_TERM_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackagePNP_UTIL_FUNC - show dependent code
PL/SQL PackagePNT_PAYMENT_TERMS_PKG - show dependent code
SynonymPN_INDEX_EXCLUDE_TERM
SynonymPN_INDEX_LEASES_ALL
ViewPN_PAYMENT_TERMS_V

APPS.PN_INDEX_EXCLUDE_TERM_V is not referenced by any database object