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_ITEMS_V

Object Details

Object Name:	PN_PAYMENT_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_PAYMENT_ITEMS_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
ROW_ID	ROWID	(10)
PAYMENT_ITEM_ID	NUMBER		Uniquely identifies a payment or a billing item row.
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DUE_DATE	DATE		Due date of a payment or billing item
SET_OF_BOOKS_ID	NUMBER		General Ledger Set of Books used. Associates the row in GL_SETS_OF_BOOKS with the payment or billing item row.
CURRENCY_CODE	VARCHAR2	(15)	Functional currency code.
RATE	NUMBER		Currency conversion rate
PAYMENT_ITEM_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Identifies the type of payment or billing item. Valid values: CASH and NORMALIZED.
PAYMENT_SCHEDULE_ID	NUMBER		Associates the payment schedule row in PN_PAYMENT_SCHEDULES_ALL with the payment or billing item row
PAYMENT_TERM_ID	NUMBER		Associates the payment term row in PN_PAYMENT_TERMS_ALL with the payment or billing item row
VENDOR_ID	NUMBER		Associates the row in PO_VENDORS with the payment or billing item. The data element is null for a billing item row.
VENDOR_SITE_ID	NUMBER		Associates the row in PO_VENDOR_SITES with the payment or billing item. The data element is null for a billing item row.
CUSTOMER_ID	NUMBER		Associates the customer row in HZ_CUST_ACCOUNTS with the transaction row. The data element is null for a payment item row.
CUSTOMER_SITE_USE_ID	NUMBER		Associates the customer's bill to site with the transaction row. The data element is null for a payment item row.
ACTUAL_AMOUNT	NUMBER		Actual amount to be paid or billed
ESTIMATED_AMOUNT	NUMBER		The estimate amount to be paid or billed
ACCOUNTED_AMOUNT	NUMBER		Holds value of actual amount in functional currency, converted using user defined conversion type
ACCOUNTED_DATE	DATE		The date on which the accounted amount is calculated.
PERIOD_FRACTION	NUMBER		Reserved for rent calculation. Please do not use.
DESCRIPTION	VARCHAR2	(50)	Obsolete. To be deleted
COMMENTS	VARCHAR2	(240)	Obsolete. To be deleted
TRANSFERRED_TO_AP_FLAG	VARCHAR2	(1)	Identifies whether this transaction has been transferred to Oracle Accounts Payable interface tables. Valid values: Y - Transferred, N- Not Transferred. The data element is null for a billing item row.
AP_INVOICE_NUM	VARCHAR2	(50)	Stores the invoice number generated by Oracle Accounts Payable for a payment item. The data element is null for a billing item row.
ENTERED_BY_LEASE	VARCHAR2	(1)	Identify whether this transaction was created through the lease process or during Authorizing payment or billing items. Valid values: N - Not created by lease, NULL - Created by lease.
CUST_SHIP_SITE_ID	NUMBER	(15)	Customer Site Id for customer ship to site.
CUST_SHIP_SITE_USE	VARCHAR2	(40)	Site use identifier
PAYMENT_PURPOSE	VARCHAR2	(80)	Identifies the purpose of the term, for example whether it is for rent, operating expense, insurance, etc.
PAYMENT_TERM_TYPE	VARCHAR2	(80)	Identifies the type of the term, fore example, base, escalation, pre-payment, etc.
ONE_TIME	VARCHAR2	(1)	The frequency of the term, specifying how often this term will come into effect, for example, monthly, annually, etc.
CODE_COMBINATION_ID	NUMBER		Associates the account id in GL_CODE_COMBINATIONS table with the lease term
TERM_NORMALIZE_FLAG	VARCHAR2	(1)	Identify whether the Items related to the term need to be Normalized. valid Values: Y - Normalize, N - Don not Normalize
TERM_ACTUAL_AMOUNT	NUMBER		The amount to be paid or billed
TERM_ESTIMATED_AMOUNT	NUMBER		The estimated amount to be paid or billed
VENDOR_NAME	VARCHAR2	(240)	Supplier name
VENDOR_NUMBER	VARCHAR2	(30)	Supplier number
CUSTOMER_NUMBER	VARCHAR2	(30)	Account Number
VENDOR_SITE	VARCHAR2	(15)	Site code name
TAX_FLAG	VARCHAR2	(0)	Tax Flag
CUSTOMER_NAME	VARCHAR2	(360)	Name of this party
CUSTOMER_SITE_USE	VARCHAR2	(40)	Site use identifier
GROUPING_RULE_ID	NUMBER	(15)	Associates the grouping rule name in PN_PAY_GROUP_RULES_ALL with the payment item.
INV_GROUP_NAME	VARCHAR2	(30)	Grouping rule name
ADJ_START_DATE	DATE		Start Date of adjustment item created.
ADJ_END_DATE	DATE		End Date of adjustment item created
LAST_ADJUSTMENT_TYPE_CODE	VARCHAR2	(30)	Code for last Adjustment Type, as a result of which the adjustment item has been created.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment
CUST_TRX_TYPE_ID	NUMBER	(15)	Transaction Type Id to be passed to AR.
DISTRIBUTION_SET_ID	NUMBER	(15)	Distribution Set Id to be passed into AP.
AP_AR_TERM_ID	NUMBER	(15)	Payment Term Id for calculation of Term date.
PROJECT_ID	NUMBER	(15)	Project Id for calculating account id in AP.
TASK_ID	NUMBER	(15)	Task Id for calculating account id in AP.
ORGANIZATION_ID	NUMBER	(15)	Organization Id for calculating account id in AP.
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure Type for calculating Account Id in AP.
EXPENDITURE_ITEM_DATE	DATE		Expenditure Item Date for calculating Account Id in AP.
TAX_GROUP_ID	NUMBER	(15)	Tax Group Id for AP.
TAX_CODE_ID	NUMBER	(15)	Tax Code Id for AP/AR.
TAX_INCLUDED	VARCHAR2	(1)	Tax included is an indicator to show that tax is included or not.
INV_RULE_ID	NUMBER	(15)	Invoice Rule Id to be passed into AR.
ACCOUNT_RULE_ID	NUMBER	(15)	Accounting Rule Id to be passed into AR.
SALESREP_ID	NUMBER	(15)	Salesperson Id to be passed into AR
CUST_PO_NUMBER	VARCHAR2	(50)	Status of Index Payment Term.
RECEIPT_METHOD_ID	NUMBER	(15)	Receipt Method Id.
TERM_TEMPLATE_ID	NUMBER	(15)	Term Template ID of Term Template, which is used to default term details at term level
ORG_ID	NUMBER	(15)	Organization identifier
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)	Tax Classification Code
TCC_PAYMENT	VARCHAR2	(80)	Tax Classification for a Payment Term
TCC_BILLING	VARCHAR2	(80)	Tax Classification for a Billing Term

Query Text

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


SELECT ROW_ID
,      PAYMENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DUE_DATE
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      RATE
,      PAYMENT_ITEM_TYPE_LOOKUP_CODE
,      PAYMENT_SCHEDULE_ID
,      PAYMENT_TERM_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      ACTUAL_AMOUNT
,      ESTIMATED_AMOUNT
,      ACCOUNTED_AMOUNT
,      ACCOUNTED_DATE
,      PERIOD_FRACTION
,      DESCRIPTION
,      COMMENTS
,      TRANSFERRED_TO_AP_FLAG
,      AP_INVOICE_NUM
,      ENTERED_BY_LEASE
,      CUST_SHIP_SITE_ID
,      CUST_SHIP_SITE_USE
,      PAYMENT_PURPOSE
,      PAYMENT_TERM_TYPE
,      ONE_TIME
,      CODE_COMBINATION_ID
,      TERM_NORMALIZE_FLAG
,      TERM_ACTUAL_AMOUNT
,      TERM_ESTIMATED_AMOUNT
,      VENDOR_NAME
,      VENDOR_NUMBER
,      CUSTOMER_NUMBER
,      VENDOR_SITE
,      TAX_FLAG
,      CUSTOMER_NAME
,      CUSTOMER_SITE_USE
,      GROUPING_RULE_ID
,      INV_GROUP_NAME
,      ADJ_START_DATE
,      ADJ_END_DATE
,      LAST_ADJUSTMENT_TYPE_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CUST_TRX_TYPE_ID
,      DISTRIBUTION_SET_ID
,      AP_AR_TERM_ID
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      TAX_GROUP_ID
,      TAX_CODE_ID
,      TAX_INCLUDED
,      INV_RULE_ID
,      ACCOUNT_RULE_ID
,      SALESREP_ID
,      CUST_PO_NUMBER
,      RECEIPT_METHOD_ID
,      TERM_TEMPLATE_ID
,      ORG_ID
,      TAX_CLASSIFICATION_CODE
,      TCC_PAYMENT
,      TCC_BILLING
FROM APPS.PN_PAYMENT_ITEMS_V;

Dependencies

[top of page]

APPS.PN_PAYMENT_ITEMS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_LOOKUP_VALUES; HZ_CUST_ACCOUNTS_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; PN_LEASES_ALL; PN_PAYMENT_ITEMS; PN_PAYMENT_TERMS_ALL; PN_PAY_GROUP_RULES; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.PN_PAYMENT_ITEMS_V is not referenced by any database object