Results for “credit_process_flag”
36 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_CRDL_REVERSAL_RATE_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined within the Projects (PA) product family. It exposes reversal-related rate information for customer revenue distribution lines, allowing inquiry forms, reports, and integration logic to retrieve the exchange rate attributes originally applied to an invoice line that is now being reversed, reversed, or adjusted. The view operates against the billing tables that underlie Oracle Projects revenue and invoicing, and it is validated (VALID) in the ETRM repository for release 12.2.2 with lineage extending back to 12.1.1.
The view is not a base transactional table; it is a query composition over three primary billing tables plus a package function. Its purpose is to reconcile a customer revenue distribution line against the draft invoice item that generated it, and to surface the invoice rate type, rate date, and exchange rate that must be reused when reversing or re-rating revenue. This is significant in multi-currency project billing, where a reversal must mirror the original invoice rate rather than the current rate.
Underlying Base Objects
The documented base objects referenced by the view are:
- PA_CUST_REV_DIST_LINES_ALL (synonym) — customer revenue distribution lines, the primary driver of the query.
- PA_DRAFT_INVOICE_ITEMS (synonym) — draft invoice items holding INV_RATE_TYPE, INV_RATE_DATE, and INV_EXCHANGE_RATE.
- PA_EXPENDITURE_ITEMS_ALL (synonym) — expenditure items used to detect adjustment relationships.
- PA_BILLING (package) — supplies the PL/SQL function PA_BILLING.GETPROJID, which restricts results to the current project context.
The view text is a three-way UNION. The first branch joins the distribution line to itself (CRDL1) via EXPENDITURE_ITEM_ID and LINE_NUM_REVERSED, linking to the draft invoice item to obtain the original rate. The second branch follows the expenditure item adjustment chain through EI.ADJUSTED_EXPENDITURE_ITEM_ID, selecting the maximum line number for the adjusted item. The third branch returns NULL rate columns for lines where no adjustment and no prior reversal exist, yielding the full working set for the project. All branches filter on INVOICE_ELIGIBLE_FLAG = 'Y' and CRDL.PROJECT_ID = PA_BILLING.GETPROJID.
Key Columns
- EXPENDITURE_ITEM_ID — identifier of the expenditure item associated with the revenue distribution line.
- LINE_NUM — the customer revenue distribution line number for that expenditure item.
- INV_RATE_TYPE — the invoice exchange rate type (e.g., Corporate, Spot) from the draft invoice item; NULL in the third UNION branch.
- INV_RATE_DATE — the rate date used on the original invoice; NULL where no sourced invoice item exists.
- INV_EXCHANGE_RATE — the actual exchange rate applied to the original invoice line; NULL when not applicable.
- CREDIT_PROCESS_FLAG — a literal 'X' constant returned by the first two branches, used as a marker to distinguish reversal/adjustment rows from unmapped rows returned by the third branch.
Common Use Cases and Queries
The primary use case is to determine the correct historical rate for reversing an invoice line or processing a credit memo. A typical query retrieves reversal rates for a specific expenditure item:
- SELECT expenditure_item_id, line_num, inv_rate_type, inv_rate_date, inv_exchange_rate, credit_process_flag FROM pa_crdl_reversal_rate_v WHERE expenditure_item_id = :p_expenditure_item_id;
- SELECT expenditure_item_id, line_num, inv_exchange_rate FROM pa_crdl_reversal_rate_v WHERE line_num = :p_line_num AND credit_process_flag = 'X';
- Filtering rows where INV_EXCHANGE_RATE IS NULL isolates lines with no invoice-backed rate, which typically require manual rate handling or fall through the third branch.
Because the view invokes PA_BILLING.GETPROJID, callers must ensure the package's project context is properly initialized before querying; otherwise results may be empty or mis-filtered. Reports and concurrent programs in Oracle Projects that need to reproduce original invoice rates without re-deriving them from current rate tables should use this view rather than joining the billing tables directly.
-
APPS.PA_CRDL_REVERSAL_RATE_V·↳ PA_BILLING·↳ PA_CUST_REV_DIST_LINES_ALL·↳ PA_DRAFT_INVOICE_ITEMS·Explore PA module →
-
Pa_Draft_Invoice_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
Pa_Draft_Invoice_Items_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
10SC Only
APPS.PA_DRAFT_INVOICE_LINES_ALL_V·↳ AR_LOOKUPS·↳ AR_VAT_TAX_ALL·↳ HZ_CUST_ACCT_SITES_ALL·Explore PA module →
-
10SC Only
APPS.PA_DRAFT_INVOICE_LINES_ALL_V·↳ AR_LOOKUPS·↳ AR_VAT_TAX_ALL·↳ HZ_CUST_ACCT_SITES_ALL·Explore PA module →
-
10SC Only
APPS.PA_DRAFT_INVOICE_LINES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS·Explore PA module →
-
Draft invoice lines
-
10SC Only
APPS.PA_DRAFT_INVOICE_LINES_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCT_SITES_ALL·Explore PA module →
-
Draft invoice lines
-
Single currency view
Not implemented in this database·Explore PA module →
-
Single currency view
Not implemented in this database·Explore PA module →
-
eTRM - PA Tables and Views 12.2.2
-
eTRM - PA Tables and Views 12.1.1