[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:	PN.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

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

FND_GLOBAL - show dependent code

FND_LOOKUPS

HZ_CUST_ACCOUNTS

HZ_CUST_SITE_USES_ALL

HZ_PARTIES

PNP_UTIL_FUNC - show dependent code

PNT_PAYMENT_TERMS_PKG - show dependent code

PN_LEASES_ALL

PN_OPEX_AGREEMENTS_ALL

PN_OPEX_RECON_ALL

PN_PAYMENT_TERMS

PN_PAY_GROUP_RULES

PN_REC_AGREEMENTS_ALL

PN_REC_AGR_LINES_ALL

PN_TERM_TEMPLATES_ALL

PO_VENDORS

PO_VENDOR_SITES_ALL

APPS

PN_INDEX_EXCLUDE_TERM_V