Results for “payment_function”
2 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PN_PAYMENT_TERMS_V is a form-driven database view owned by the APPS schema in Oracle E-Business Suite, and it is documented as VALID across the 12.1.1 and 12.2.2 releases. It belongs to the Property Manager (PN) product family and serves as the presentation-layer view that a Payment Terms form uses to enter and maintain payment term information for leases, operating expense (OPEX) agreements, and recovery agreements. The view is not a standalone reporting object by design; it is the interface that the PN payment terms form reads from and writes to, exposing the columns the form requires for currency, schedule, tax, and reference attributes.
For reporting and integration purposes, PN_PAYMENT_TERMS_V provides a denormalized read point over the underlying PN_PAYMENT_TERMS synonym, resolving selected payment-purpose, frequency, lease, vendor, customer, and accounting flexfield values so that a query against the view returns a form-ready record set.
Underlying Base Objects
The documented base objects include the base table synonym PN_PAYMENT_TERMS, which supplies the primary rows and most columns. Supporting PN objects include PN_LEASES_ALL, PN_OPEX_AGREEMENTS_ALL, PN_OPEX_RECON_ALL, PN_REC_AGREEMENTS_ALL, PN_REC_AGR_LINES_ALL, PN_TERM_TEMPLATES_ALL, and PN_PAY_GROUP_RULES, providing lease and agreement context and term templates. Supplier references resolve through PO_VENDORS and PO_VENDOR_SITES_ALL, while customer references resolve through HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES_ALL, and HZ_PARTIES. Value translation uses FND_LOOKUPS and the package FND_GLOBAL, and logic is encapsulated in the packages PNT_PAYMENT_TERMS_PKG and PNP_UTIL_FUNC, both of which contribute decoded and derived values to the view text.
Key Columns
- ROW_ID — the ROWID of the underlying PN_PAYMENT_TERMS row, used by the form for update locking.
- PAYMENT_TERM_ID — primary identifier linking each row to its payment term definition.
- PAYMENT_PURPOSE_CODE, PAYMENT_TERM_TYPE_CODE, FREQUENCY_CODE, NORMALIZE — classify the term's purpose, type, payment frequency, and normalization behavior.
- LEASE_ID, LEASE_CHANGE_ID, VENDOR_ID, VENDOR_SITE_ID, CUSTOMER_ID, CUSTOMER_SITE_USE_ID, CUST_SHIP_SITE_ID — reference the lease, change order, supplier, and customer parties and sites involved.
- START_DATE, END_DATE, TARGET_DATE, SCHEDULE_DAY — govern the term's effective window and scheduling.
- ACTUAL_AMOUNT, ESTIMATED_AMOUNT, CURRENCY_CODE, RATE, SET_OF_BOOKS_ID — carry monetary and accounting ledger context.
- AP_AR_TERM_ID, CUST_TRX_TYPE_ID, TAX_GROUP_ID, TAX_CODE_ID — link to Payables/Receivables terms, transaction types, and tax configuration.
- PROJECT_ID, TASK_ID, ORGANIZATION_ID, EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE — provide project and expenditure detail for cost-driven payment terms.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield segment columns available for extension.
Common Use Cases and Queries
Typical usage includes extracting payment terms for a specific lease, reconciling estimated against actual amounts, and validating currency and rate values for downstream AP/AR processing. A representative query is:
SELECT payment_term_id, lease_id, payment_purpose_code,
frequency_code, start_date, end_date,
estimated_amount, actual_amount, currency_code
FROM apps.pn_payment_terms_v
WHERE lease_id = :lease_id
AND end_date >= SYSDATE;
Investigate supplier or customer association by filtering on VENDOR_ID/CUSTOMER_ID, or join the view back to PN_LEASES_ALL on LEASE_ID to obtain lease attributes not exposed directly by the view. Because the view is form-oriented and built partly from package logic (PNT_PAYMENT_TERMS_PKG, PNP_UTIL_FUNC), integrations should query the base PN_PAYMENT_TERMS table directly when only persisted columns are required.
-
View: PN_PAYMENT_TERMS_V 12.2.2
Form view used to input payment terms information
APPS.PN_PAYMENT_TERMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: PN_PAYMENT_TERMS_V 12.1.1
Form view used to input payment terms information
APPS.PN_PAYMENT_TERMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →