Results for “charge_periodicity_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OE_PRN_CHG_PERIODICITY_V view is an Oracle Order Management (ONT) reporting object owned by the APPS schema. It is documented as a VALID view in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its stated purpose is to obtain recurring charge information while printing a Sales Order. The view returns the periodic (recurring) charge codes associated with sales order lines, resolved to the transaction currency carried on the parent order header.
Because periodicity codes determine whether a charge recurs weekly, monthly, quarterly, annually, or is charged only once, this view supplies the print and reporting layer with a compact, de-duplicated result set of header, charge periodicity, and transaction currency. It sits in the reporting/integration tier — it is not a transactional entry point and carries no DML — and is typically consumed by order-print programs, custom concurrent requests, BI Publisher layouts, and inbound/outbound interfaces that must reproduce the periodicity and currency context of a sales order.
The user search term transactional_curr_code maps directly to the exposed column TRANSACTIONAL_CURR_CODE, which is the currency of the transaction as recorded on the order header. This makes the view useful wherever recurring charge amounts must be formatted or converted in the order's transactional currency rather than in functional currency.
Underlying Base Objects
The view is defined over two synonym-referenced base tables in the APPS schema:
- OE_ORDER_HEADERS_ALL — aliased
H; the source ofTRANSACTIONAL_CURR_CODEand the header identity used for the join. - OE_ORDER_LINES_ALL — aliased
L; the source ofHEADER_IDandCHARGE_PERIODICITY_CODE.
The documented view text is a correlated join:
SELECT DISTINCT L.HEADER_ID, NVL(L.CHARGE_PERIODICITY_CODE,'ONE'), H.TRANSACTIONAL_CURR_CODE FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L WHERE L.HEADER_ID = H.HEADER_ID
The join is a simple equijoin on HEADER_ID. The DISTINCT operator collapses the many order lines that share a header into a single row per distinct header/periodicity/currency combination. The NVL wrapper substitutes the literal value 'ONE' when a line's periodicity code is null, ensuring the print layer always receives a non-null periodicity token. Note that because the join is on header alone, the result is not scoped to a specific line; it reports the set of periodicity codes present across all lines of each order.
Key Columns
- HEADER_ID — Surrogate primary key of the order header in
OE_ORDER_HEADERS_ALL. Used to group and to link the view back to the order for printing or further joins. - CHARGE_PERIODICITY_CODE — The periodicity of the recurring charge, sourced from
OE_ORDER_LINES_ALL.CHARGE_PERIODICITY_CODE. Nulls are returned as the literal'ONE'by theNVLexpression, indicating a single (non-recurring) charge. - TRANSACTIONAL_CURR_CODE — The transactional currency code of the order, taken from
OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE. This is the column matched by the search term transactional_curr_code.
Common Use Cases and Queries
Typical scenarios include reproducing recurring charge periodicity on printed sales orders, validating which orders carry more than one periodicity code, and extracting transactional currency alongside periodicity for downstream formatting or interface staging.
Retrieve periodicity and transaction currency for a specific order:
SELECT header_id, charge_periodicity_code, transactional_curr_code FROM oe_prn_chg_periodicity_v WHERE header_id = :header_id;
Identify orders carrying recurring (non-'ONE') charges in a given currency:
SELECT header_id, charge_periodicity_code FROM oe_prn_chg_periodicity_v WHERE transactional_curr_code = 'USD' AND charge_periodicity_code <> 'ONE';
Join back to the header for printing context:
SELECT v.header_id, v.charge_periodicity_code, v.transactional_curr_code, h.order_number FROM oe_prn_chg_periodicity_v v, oe_order_headers_all h WHERE v.header_id = h.header_id AND h.org_id = :org_id;
Because the view is DISTINCT and header-scoped, queries should treat it as a periodicity/currency summary per order rather than as a line-level detail source; line-level periodicity must be read from OE_ORDER_LINES_ALL directly.
-
The view is for obtaining recurring charges while printing a Sales Order
APPS.OE_PRN_CHG_PERIODICITY_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
Base BIS Business View for Order Cancellations.
APPS.OEBV_ORDER_CANCELLATIONS·↳ OE_ORDER_LINES_HISTORY·Explore ONT module →
-
Base BIS Business View for Order Cancellations.
APPS.OEBV_ORDER_CANCELLATIONS·↳ OE_ORDER_LINES_HISTORY·Explore ONT module →
-
APPS.OE_AK_INVENTORY_ITEMS_V·↳ MTL_SYSTEM_ITEMS·↳ OE_SYS_PARAMETERS·Explore ONT module →
-
APPS.OEFV_ORDER_CANCELLATIONS·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_HISTORY·Explore ONT module →
-
APPS.OEFV_ORDER_CANCELLATIONS·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_HISTORY·Explore ONT module →
-
APPS.OE_AK_INVENTORY_ITEMS_V·↳ MTL_SYSTEM_ITEMS·↳ OE_SYS_PARAMETERS·Explore ONT module →
-
The view is for obtaining recurring charges while printing a Sales Order
APPS.OE_PRN_CHG_PERIODICITY_V·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
- Retrofitted
APPS.OEBV_ORDER_CANCELLATIONS·↳ OE_ORDER_LINES_HISTORY·Explore OE module →
-
View: QP_PREQ_LINES_TMP 12.2.2
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LINES_TMP·↳ QP_PREQ_LINES_TMP_T·Explore QP module →
-
- Retrofitted
APPS.OEBV_ORDER_CANCELLATIONS·↳ OE_ORDER_LINES_HISTORY·Explore OE module →
-
Table: QP_PREQ_LINES_TMP_T1 12.2.2
-
APPS.ASO_PVT_QUOTE_LINES_BALI_V·↳ ASO_LINE_NUM_INT·↳ ASO_PVT_QUOTE_LINES_NUM_V·↳ FND_PROFILE·Explore ASO module →
-
- Retrofitted
APPS.OEFV_ORDER_CANCELLATIONS·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_HISTORY·Explore OE module →
-
- Retrofitted
APPS.OEFV_ORDER_CANCELLATIONS·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_HISTORY·Explore OE module →
-
Table: QP_INT_LINES_T 12.1.1
Permanent table for holding the elements in the calling application that requires a base and adjusted price.
-
View: OEBV_ORDER_LINES 12.2.2
-
Table: QP_PREQ_LINES_TMP_T 12.1.1
-
View: QP_PREQ_LINES_TMP 12.1.1
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LINES_TMP·↳ QP_PREQ_LINES_TMP_T·Explore QP module →
-
View: IBE_ORDER_DETAIL_V 12.2.2
Stores information about details of an order line
APPS.IBE_ORDER_DETAIL_V·↳ CZ_CONFIG_DETAILS_V·↳ CZ_UTILS·↳ FND_PROFILE·Explore IBE module →
-
View: OEBV_ORDER_LINES 12.1.1
-
View: MTL_SYSTEM_ITEMS_VL 12.1.1
System Items multilingual view with concatenated segments column
APPS.MTL_SYSTEM_ITEMS_VL·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_FVL 12.1.1
Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.
APPS.MTL_SYSTEM_ITEMS_FVL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_FVL 12.2.2
Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.
APPS.MTL_SYSTEM_ITEMS_FVL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_B_KFV 12.2.2
System Items Key Flexfield View
APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →
-
View: OE_PRN_ORDER_LINES_V 12.2.2
The view is for obtaining line details for printing a sales order
APPS.OE_PRN_ORDER_LINES_V·↳ FND_CURRENCY·↳ MTL_CROSS_REFERENCES·↳ MTL_CUSTOMER_ITEMS·Explore ONT module →
-
APPS.ASO_PVT_QUOTE_LINES_BALI_V·↳ ASO_LINE_NUM_INT·↳ ASO_PVT_QUOTE_LINES_NUM_V·↳ FND_PROFILE·Explore ASO module →
-
ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line
-
View: MTL_SYSTEM_ITEMS_B_KFV 12.1.1
System Items Key Flexfield View
APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →
-
View: OEFV_ORDER_LINES 12.2.2
Full BIS View for Order lines
APPS.OEFV_ORDER_LINES·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ MTL_SYSTEM_ITEMS_VL·Explore ONT module →
-
View: OEFV_ORDER_LINES 12.1.1
Full BIS View for Order lines
APPS.OEFV_ORDER_LINES·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ MTL_SYSTEM_ITEMS_VL·Explore ONT module →
-
View: IBE_ORDER_DETAIL_V 12.1.1
Stores information about details of an order line
APPS.IBE_ORDER_DETAIL_V·↳ CZ_CONFIG_DETAILS_V·↳ CZ_UTILS·↳ FND_PROFILE·Explore IBE module →
-
View: EGO_ITEM_SYNC_V 12.2.2
This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel
APPS.EGO_ITEM_SYNC_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →
-
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
-
This table is used to store Pending Changes information for the Items
-
View: OE_ORDER_LINES_V 12.2.2
View for Order Lines used in the Sales Order form.
APPS.OE_ORDER_LINES_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
Inventory Items Open Interface table
-
This view stores the pending changes information for item operational attributes
APPS.EGO_MTL_SY_ITEMS_CHG_VL·↳ EGO_MTL_SY_ITEMS_CHG_B·↳ EGO_MTL_SY_ITEMS_CHG_TL·Explore EGO module →
-
View: MTL_ITEM_FLEXFIELDS 12.1.1
This view is based on the key flexfield view MTL_SYSTEM_ITEMS_B_KFV. It contains columns with padded and unpadded concatenated segments of an item number.
APPS.MTL_ITEM_FLEXFIELDS·↳ MTL_SYSTEM_ITEMS_B_KFV·Explore INV module →
-
View: MTL_CLIENT_ITEMS_VL 12.2.2
APPS.MTL_CLIENT_ITEMS_VL·↳ MTL_CLIENT_PARAMETERS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore INV module →
-
View: EGO_ITEM_SYNC_V 12.1.1
This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel
APPS.EGO_ITEM_SYNC_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →
-
View: MTL_SYSTEM_ITEMS_VL 12.2.2
System Items multilingual view with concatenated segments column
APPS.MTL_SYSTEM_ITEMS_VL·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
Table: QP_INT_LINES_T 12.2.2
Permanent table for holding the elements in the calling application that requires a base and adjusted price.
-
View: OE_PRN_ORDER_LINES_V 12.1.1
The view is for obtaining line details for printing a sales order
APPS.OE_PRN_ORDER_LINES_V·↳ FND_CURRENCY·↳ MTL_CROSS_REFERENCES·↳ MTL_CUSTOMER_ITEMS·Explore ONT module →
-
ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line
-
View: OE_ORDER_LINES_HIST_V 12.2.2
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
This table stores information about the acknowledgements for Order Lines.
-
This table stores information about the acknowledgements for Order Lines.