eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PN_PAYMENT_TERMS_HISTORY_V

Object Details

Object Name:	PN_PAYMENT_TERMS_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_PAYMENT_TERMS_HISTORY_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	Comments
TERM_HISTORY_ID	NUMBER	(15)	Unique Identifier of the term history row. This is the primary key of table.
PREV_TERM_HISTORY_ID	NUMBER	(15)	Reference column to previous term history row of the same term.
DISTRIBUTION_CHANGE_ID	NUMBER	(15)	Reference column to PN_DISTRIBUTIONS_HISTORY table.
PAYMENT_TERM_ID	NUMBER	(15)	Term Id, to which term history row belongs .
LAST_UPDATE_DATE	DATE		Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO column.
CREATION_DATE	DATE		Standard WHO column.
CREATED_BY	NUMBER	(15)	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard WHO column.
PAYMENT_PURPOSE_CODE	VARCHAR2	(30)	Identifies the purpose of the term history row.
PAYMENT_TERM_TYPE_CODE	VARCHAR2	(30)	Identifies the type of the term history row, for example, base, escalation, pre-payment, etc.
FREQUENCY_CODE	VARCHAR2	(30)	The frequency of the term history row, specifying how often the term would come into effect, for example, monthly, annually, etc.
NORMALIZE	VARCHAR2	(1)	Identify whether the Items related to the term history need to be Normalized. valid Values: Y - Normalize, N - Don not Normalize.
LEASE_ID	NUMBER	(15)	Associates the lease row in PN_LEASES_ALL with the term history row.
LEASE_CHANGE_ID	NUMBER	(15)	Associates the lease, amend, or edit row in PN_LEASE_CHANGES_ALL with the term history row.
START_DATE	DATE		History of start date of the term.
END_DATE	DATE		History of end date of the term.
VENDOR_ID	NUMBER	(15)	Associates the row in PO_VENDORS with the term history row. The data element is null for a billing term history row.
VENDOR_SITE_ID	NUMBER	(15)	Associates the row in PO_VENDOR_SITES with the term history row. The data element is null for a billing term history row.
CUSTOMER_ID	NUMBER	(15)	Associates the customer row in HZ_CUST_ACCOUNTS with the term history row. The data element is null for a payment term history row.
CUSTOMER_SITE_USE_ID	NUMBER	(15)	Associate the customer's bill to site with the term history row. The data element is null for a payment type history row.
TARGET_DATE	DATE		History of date on which the term of the type PRE-PAYMENT was to be offset with the due date. For all other terms, this data element is null.
ACTUAL_AMOUNT	NUMBER		History of amount to be paid or billed.
ESTIMATED_AMOUNT	NUMBER		History of estimated amount to be paid or billed.
SET_OF_BOOKS_ID	NUMBER	(15)	General Ledger Set of Books used. Associates the row in GL_SETS_OF_BOOKS with the payment or billing term history row.
CURRENCY_CODE	VARCHAR2	(15)	Functional currency code.
RATE	NUMBER		Currency conversion rate.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive Flexfield Structure Defining column.
ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flexfield Segment column.
ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flexfield Segment column.
LOCATION_ID	NUMBER	(15)	Associates the location row in PN_LOCATIONS_ALL with the term history row.
SCHEDULE_DAY	NUMBER	(15)	Day of the month on which schedules are to be created and it is used to derive the schedule dates of term.
CUST_SHIP_SITE_ID	NUMBER	(15)	Associate the customer's ship to site with the term history row. The data element is null for a payment type history row.
AP_AR_TERM_ID	NUMBER	(15)	History of Term Id populated from Payables/Receivables to calculate the Due Date.
CUST_TRX_TYPE_ID	NUMBER	(15)	History of Transaction Type Id populated from Receivables and passed to Receivables while exporting an invoice.
PROJECT_ID	NUMBER	(15)	History of Project Id for calculating account id in Payables.
TASK_ID	NUMBER	(15)	History of Task Id for calculating account id in Payables.
ORGANIZATION_ID	NUMBER	(15)	History of Organization Id for calculating account id in Payables.
EXPENDITURE_TYPE	VARCHAR2	(30)	History of Expenditure Type for calculating account id in Payables.
EXPENDITURE_ITEM_DATE	DATE		History of Expenditure Item Date for calculating account id in Payables.
TAX_GROUP_ID	NUMBER	(15)	History of Tax Group Id, populated from Payables and passed to Payables while exporting payment item.
TAX_CODE_ID	NUMBER	(15)	History of Tax Code Id, populated from Payables/Receivables and passed to Payables/Receivables while exporting an item.
TAX_INCLUDED	VARCHAR2	(1)	History of Tax Included indicator.
DISTRIBUTION_SET_ID	NUMBER	(15)	History of Distribution Set Id.
INV_RULE_ID	NUMBER	(15)	History of Invoice Rule Id.
ACCOUNT_RULE_ID	NUMBER	(15)	History of Salesrep Id.
SALESREP_ID	NUMBER	(15)	History of Salesrep Id.
APPROVED_BY	NUMBER	(15)	Approver Name for Index Payment Term.
STATUS	VARCHAR2	(30)	Status of Index Payment Terms.
INDEX_PERIOD_ID	NUMBER	(15)	Associates Index Period row of Index Period Term with the term history row.
INDEX_TERM_INDICATOR	VARCHAR2	(30)	Identifies whether the payment term is for backbill or recurring .
PO_HEADER_ID	VARCHAR2	(30)	History of Purchase Order Header Id.
CUST_PO_NUMBER	VARCHAR2	(50)	History of Purchase Order Number.
RECEIPT_METHOD_ID	NUMBER	(15)	History of Receipt Method Identifier.
VAR_RENT_INV_ID	NUMBER	(15)	Associates the row in this table with a variable rent invoice row in table pn_var_rent_inv_all.
VAR_RENT_TYPE	VARCHAR2	(20)	Determines the term type if term is a variable rent term. The column can have one of the following values ,'ACTUAL', 'FORECASTED' or 'VARIANCE'.
CHANGED_FLAG	VARCHAR2	(20)	Indicates whether the term was changed or not.
RECOVERABLE_FLAG	VARCHAR2	(1)	Identifies whether the billing term is used for recovery purposes.
PERIOD_BILLREC_ID	NUMBER	(15)	Associates a billed record for a period from PN_REC_PERIOD_BILL_ALL table with term history row.
REC_AGR_LINE_ID	NUMBER	(15)	Associates a line for a billed record for a period from PN_REC_PERIOD_BILL_ALL table with term history row.
AMOUNT_TYPE	VARCHAR2	(30)	Amount Type of the term history row.
NORM_START_DATE	DATE		Normalization start date of the term.
INTERFACE_LINE_CONTEXT	VARCHAR2	(30)	Project Attribute Category for passing Context to AR.
INTERFACE_LINE_ATTRIBUTE1	VARCHAR2	(150)	Segment1 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE2	VARCHAR2	(150)	Segment2 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE3	VARCHAR2	(150)	Segment3 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE4	VARCHAR2	(150)	Segment4 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE5	VARCHAR2	(150)	Segment5 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE6	VARCHAR2	(150)	Segment6 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE7	VARCHAR2	(150)	Segment7 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE8	VARCHAR2	(150)	Segment8 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE9	VARCHAR2	(150)	Segment9 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE10	VARCHAR2	(150)	Segment10 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE11	VARCHAR2	(150)	Segment11 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE12	VARCHAR2	(150)	Segment12 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE13	VARCHAR2	(150)	Segment13 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE14	VARCHAR2	(150)	Segment14 for Project Flex field.
INTERFACE_LINE_ATTRIBUTE15	VARCHAR2	(150)	Segment15 for Project Flex field.
TERM_TEMPLATE_ID	NUMBER	(15)	Associates Term Template row with the term history row.
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)
TERM_TEMPLATE	VARCHAR2	(100)
TERM_COMMENTS	VARCHAR2	(2000)
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)
TCC_PAYMENT	VARCHAR2	(80)
TCC_BILLING	VARCHAR2	(80)

Query Text

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


SELECT TERM_HISTORY_ID
,      PREV_TERM_HISTORY_ID
,      DISTRIBUTION_CHANGE_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
,      TERM_TEMPLATE
,      TERM_COMMENTS
,      TAX_CLASSIFICATION_CODE
,      TCC_PAYMENT
,      TCC_BILLING
FROM APPS.PN_PAYMENT_TERMS_HISTORY_V;

Dependencies

[top of page]

APPS.PN_PAYMENT_TERMS_HISTORY_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; PNP_UTIL_FUNC - show dependent code; PN_LEASES_ALL; PN_PAYMENT_TERMS_HISTORY; PN_PAY_GROUP_RULES; PN_TERM_TEMPLATES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.PN_PAYMENT_TERMS_HISTORY_V is not referenced by any database object