Search Results exported_code

Overview

PN_VAR_DEDUCTIONS_V is a database view owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2, part of the Property Manager (PN) product family. ETRM documents the object with a status of VALID and describes it as a "form view used to input deductions related information." In practice, this view serves as the presentation-layer interface for the Property Manager deductions form, abstracting the underlying transaction table PN_VAR_DEDUCTIONS and enriching it with descriptive lookup text and joined parent context from the variable period and line tables. Because deductions are typically recorded against a variable period line item (for example, in percentage rent or variable rent processing), the view provides the combined record set the form requires without forcing the form to perform multiple lookups.

For reporting and integration purposes, the view is a convenient, already-joined source for deduction data. It exposes denormalized fields—such as the decoded deduction type meaning—which reduces the amount of join logic an external report or interface must replicate. The view is read-oriented; inserts and updates are directed by the form to the base table, but its structure remains useful for extract programs and custom inquiries.

Underlying Base Objects

The view is defined over four registered objects plus a lookup source, per the ETRM metadata:

• PN_VAR_DEDUCTIONS (synonym, aliased DED) — the primary base table holding deduction rows; nearly all projected columns originate here.
• PN_VAR_PERIODS_ALL (synonym, aliased PER) — joined on PERIOD_ID to supply variable period context.
• PN_VAR_LINES_ALL (synonym, aliased LINES) — joined on LINE_ITEM_ID to associate each deduction with its variable line item.
• FND_LOOKUPS (view, aliased FND) — outer-joined on LOOKUP_TYPE = 'PN_DEDUCTION_TYPE' and LOOKUP_CODE = DEDUCTION_TYPE_CODE to decode the deduction type.
• FND_GLOBAL (package) — referenced in the documented metadata, typically for session context such as org or user.

The FND_LOOKUPS join is an outer join (indicated by the (+) operator), so deductions with an unmapped or null type code are still returned. The relationships are strictly transactional: one period to many deductions, one line item to many deductions.

Key Columns

• ROW_ID — the ROWID of the base deduction row; used by the form for row-level update targeting.
• DEDUCTION_ID / DEDUCTION_NUM — surrogate primary key and user-facing deduction number.
• LINE_ITEM_ID / PERIOD_ID — foreign keys linking the deduction to its variable line and period.
• DEDUCTION_TYPE_CODE / DEDUCTION_TYPE — the stored code and its decoded meaning from FND_LOOKUPS.
• DEDUCTION_AMOUNT — the deduction value recorded for the row.
• DEDUCTION_CUM_AMT — an analytic running total of DEDUCTION_AMOUNT partitioned by LINE_ITEM_ID and ordered by DEDUCTION_NUM, giving a cumulative deduction amount per line.
• START_DATE / END_DATE / GROUP_DATE / INVOICING_DATE / GRP_DATE_ID / GL_ACCOUNT_ID — dating and accounting attributes for the deduction.
• EXPORTED_CODE — flag indicating whether the deduction has been exported (for example, to a downstream receivables or invoicing process); relevant to interface reconciliation.
• COMMENTS / ATTRIBUTE_CATEGORY / ATTRIBUTE1–15 — the standard EBS descriptive flexfield and free-text columns.
• ORG_ID — multi-org operating unit identifier, supporting operating unit security.

Common Use Cases and Queries

Typical scenarios include extract of unexported deductions, reconciliation of cumulative deductions per line, and reporting by deduction type and period.

SELECT deduction_id, deduction_num, line_item_id, period_id,
       deduction_type, deduction_amount, deduction_cum_amt,
       exported_code, org_id
FROM   apps.pn_var_deductions_v
WHERE  org_id = :p_org_id
AND    exported_code = 'N'
ORDER BY line_item_id, deduction_num;

Because the view already decodes deduction type and computes the cumulative amount, it is well suited to feeds that must report running totals by line item without additional analytic logic, and to inquiries that reconcile exported versus unexported deduction activity within a period.