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

VIEW: APPS.PN_PAYMENT_TERMS_V

Object Details
Object Name: PN_PAYMENT_TERMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPN.PN_PAYMENT_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
ROW_ID ROWID (10)
PAYMENT_TERM_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

PAYMENT_PURPOSE_CODE VARCHAR2 (30)
PAYMENT_TERM_TYPE_CODE VARCHAR2 (30)
FREQUENCY_CODE VARCHAR2 (30)
NORMALIZE VARCHAR2 (1)
LEASE_ID NUMBER

LEASE_CHANGE_ID NUMBER

START_DATE DATE

END_DATE DATE

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_USE_ID NUMBER

TARGET_DATE DATE

ACTUAL_AMOUNT NUMBER

ESTIMATED_AMOUNT NUMBER

SET_OF_BOOKS_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
RATE NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LOCATION_ID NUMBER (15)
SCHEDULE_DAY NUMBER (15)
CUST_SHIP_SITE_ID NUMBER (15)
AP_AR_TERM_ID NUMBER (15)
CUST_TRX_TYPE_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15)
EXPENDITURE_TYPE VARCHAR2 (30)
EXPENDITURE_ITEM_DATE DATE

TAX_GROUP_ID NUMBER (15)
TAX_CODE_ID NUMBER (15)
TAX_INCLUDED VARCHAR2 (1)
DISTRIBUTION_SET_ID NUMBER (15)
INV_RULE_ID NUMBER (15)
ACCOUNT_RULE_ID NUMBER (15)
SALESREP_ID NUMBER (15)
APPROVED_BY NUMBER (15)
STATUS VARCHAR2 (30)
INDEX_PERIOD_ID NUMBER

INDEX_TERM_INDICATOR VARCHAR2 (30)
PO_HEADER_ID VARCHAR2 (30)
CUST_PO_NUMBER VARCHAR2 (50)
RECEIPT_METHOD_ID NUMBER (15)
VAR_RENT_INV_ID NUMBER (38)
VAR_RENT_TYPE VARCHAR2 (20)
CHANGED_FLAG VARCHAR2 (20)
RECOVERABLE_FLAG VARCHAR2 (1)
PERIOD_BILLREC_ID NUMBER (15)
REC_AGR_LINE_ID NUMBER (15)
AMOUNT_TYPE VARCHAR2 (30)
NORM_START_DATE DATE

INTERFACE_LINE_CONTEXT VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)
TERM_TEMPLATE_ID NUMBER (15)
PAYMENT_PURPOSE VARCHAR2 (80)
PAYMENT_TERM_TYPE VARCHAR2 (80)
FREQUENCY_TYPE VARCHAR2 (80)
VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (30)
VENDOR_SITE VARCHAR2 (15)
TAX_FLAG VARCHAR2 (0)
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_NUMBER VARCHAR2 (30)
CUSTOMER_SITE_USE VARCHAR2 (40)
CUST_SHIP_SITE_USE VARCHAR2 (40)
TOTAL_PAYMENT NUMBER

LEASED_AREA NUMBER

AREA_TYPE_CODE VARCHAR2 (30)
AREA NUMBER

GROUPING_RULE_ID NUMBER (15)
INV_GROUP_NAME VARCHAR2 (30)
ORG_ID NUMBER (15)
TERM_TEMPLATE VARCHAR2 (100)
TERM_ALTERED_FLAG VARCHAR2 (1)
SOURCE_CODE VARCHAR2 (30)
TERM_COMMENTS VARCHAR2 (2000)
TAX_CLASSIFICATION_CODE VARCHAR2 (30)
TCC_PAYMENT VARCHAR2 (80)
TCC_BILLING VARCHAR2 (80)
LEGAL_ENTITY_ID NUMBER (15)
INCLUDE_IN_VAR_RENT VARCHAR2 (30)
RECUR_BB_CALC_DATE DATE

OPEX_AGR_ID NUMBER

OPEX_RECON_ID NUMBER

AGREEMENT_NUMBER VARCHAR2 (4000)
SOURCE_MODULE VARCHAR2 (4000)
AGREEMENT_NAME VARCHAR2 (90)
PAYMENT_FUNCTION VARCHAR2 (30)
RECON_PERIOD VARCHAR2 (25)
Query Text

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


SELECT ROW_ID
,      PAYMENT_TERM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_PURPOSE_CODE
,      PAYMENT_TERM_TYPE_CODE
,      FREQUENCY_CODE
,      NORMALIZE
,      LEASE_ID
,      LEASE_CHANGE_ID
,      START_DATE
,      END_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      TARGET_DATE
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      RATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LOCATION_ID
,      SCHEDULE_DAY
,      CUST_SHIP_SITE_ID
,      AP_AR_TERM_ID
,      CUST_TRX_TYPE_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      TAX_GROUP_ID
,      TAX_CODE_ID
,      TAX_INCLUDED
,      DISTRIBUTION_SET_ID
,      INV_RULE_ID
,      ACCOUNT_RULE_ID
,      SALESREP_ID
,      APPROVED_BY
,      STATUS
,      INDEX_PERIOD_ID
,      INDEX_TERM_INDICATOR
,      PO_HEADER_ID
,      CUST_PO_NUMBER
,      RECEIPT_METHOD_ID
,      VAR_RENT_INV_ID
,      VAR_RENT_TYPE
,      CHANGED_FLAG
,      RECOVERABLE_FLAG
,      PERIOD_BILLREC_ID
,      REC_AGR_LINE_ID
,      AMOUNT_TYPE
,      NORM_START_DATE
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      INTERFACE_LINE_ATTRIBUTE3
,      INTERFACE_LINE_ATTRIBUTE4
,      INTERFACE_LINE_ATTRIBUTE5
,      INTERFACE_LINE_ATTRIBUTE6
,      INTERFACE_LINE_ATTRIBUTE7
,      INTERFACE_LINE_ATTRIBUTE8
,      INTERFACE_LINE_ATTRIBUTE9
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      TERM_TEMPLATE_ID
,      PAYMENT_PURPOSE
,      PAYMENT_TERM_TYPE
,      FREQUENCY_TYPE
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE
,      TAX_FLAG
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      CUSTOMER_SITE_USE
,      CUST_SHIP_SITE_USE
,      TOTAL_PAYMENT
,      LEASED_AREA
,      AREA_TYPE_CODE
,      AREA
,      GROUPING_RULE_ID
,      INV_GROUP_NAME
,      ORG_ID
,      TERM_TEMPLATE
,      TERM_ALTERED_FLAG
,      SOURCE_CODE
,      TERM_COMMENTS
,      TAX_CLASSIFICATION_CODE
,      TCC_PAYMENT
,      TCC_BILLING
,      LEGAL_ENTITY_ID
,      INCLUDE_IN_VAR_RENT
,      RECUR_BB_CALC_DATE
,      OPEX_AGR_ID
,      OPEX_RECON_ID
,      AGREEMENT_NUMBER
,      SOURCE_MODULE
,      AGREEMENT_NAME
,      PAYMENT_FUNCTION
,      RECON_PERIOD
FROM APPS.PN_PAYMENT_TERMS_V;

Dependencies

[top of page]

APPS.PN_PAYMENT_TERMS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
PL/SQL PackagePNP_UTIL_FUNC - show dependent code
PL/SQL PackagePNT_PAYMENT_TERMS_PKG - show dependent code
SynonymPN_LEASES_ALL
SynonymPN_OPEX_AGREEMENTS_ALL
SynonymPN_OPEX_RECON_ALL
SynonymPN_PAYMENT_TERMS
SynonymPN_PAY_GROUP_RULES
SynonymPN_REC_AGREEMENTS_ALL
SynonymPN_REC_AGR_LINES_ALL
SynonymPN_TERM_TEMPLATES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.PN_PAYMENT_TERMS_V is referenced by following:

SchemaAPPS
ViewPN_INDEX_EXCLUDE_TERM_V