Results for “customer_line_number”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_LINE_SECURITY is a PL/SQL package body in the APPS schema that implements Oracle Order Management's line-level security model. Its core business purpose is to evaluate whether the current user is authorized to view, modify, or transact against a specific order line, based on attributes of that line and on the security rules configured for the operating unit and responsibility. In Oracle EBS 12.1.1 and 12.2.2, this package is invoked widely across Order Management, since access control must be enforced consistently whenever order lines are queried or updated. It is classified in the ETRM documentation as an "OTHER" API rather than a public or private user API, confirming that it is an internal utility consumed by Oracle's own forms, concurrent programs, and business logic rather than a supported integration point. The package is heavily depended upon: the documentation records that it is referenced by 234 other database objects, establishing it as a foundational component of order-line processing. It is not itself referenced by any reverse-dependent object, so it sits near the base of the Order Management dependency hierarchy.
Key Procedures and Functions
The documented interface exposes 133 procedures and functions. Because the ETRM metadata records names only, the descriptions below reflect their evident role within line security without asserting parameter signatures.
- Attribute accessors (ATTRIBUTE1 through ATTRIBUTE20): These functions retrieve the value of the corresponding descriptive flexfield or attribute column on the secured order line, allowing security rules to key on customer, region, product, or other configurable criteria.
- Line attribute functions: ACCOUNTING_RULE and ACCOUNTING_RULE_DURATION expose the accounting rule and its duration for the line; COMMITMENT_ID exposes the commitment reference; AGREEMENT exposes the agreement reference; CALCULATE_PRICE_FLAG indicates whether pricing should be recalculated; and AUTHORIZED_TO_SHIP indicates shipping authorization. These allow security predicates to be expressed in terms of order-line business attributes rather than only user identity.
Collectively these accessors supply the attribute values that security rules compare against, isolating the rule engine from the physical layout of OE_ORDER_LINES.
Tables Accessed
- OE_ORDER_LINES: The primary source of line-level data. The package reads order line attributes, flags, and context values to evaluate security conditions.
- OE_PC_CONSTRAINTS: Stores the processing constraint definitions used to derive security-relevant rules, including the constraints that govern which lines a user may act upon.
- PLITBLM: The standard Oracle Forms PL/SQL table, used to carry in-memory result sets or identifier lists within the package's forms-driven invocation paths.
These tables are reached through APPS synonyms, consistent with the package's placement in the APPS schema. Dependencies also reference OE_ORDER_PUB, OE_LINE_UTIL_EXT, OE_SALES_CAN_UTIL, and OE_GLOBALS, indicating that line security is evaluated cooperatively with the public order API and Order Management's global state.
Usage Notes
OE_LINE_SECURITY is invoked automatically rather than called directly by end users. The Order Management order-entry forms call it whenever lines are queried or manipulated, ensuring that unauthorized lines are filtered from the user's view and blocked from update. Concurrent programs that process orders—picking, shipping, invoicing, and acknowledgment generation—rely on the same security evaluation so that batch processing honors the same restrictions as interactive use. Oracle's internal packages (OE_ORDER_PUB, OE_ACKNOWLEDGMENT_PUB, and others listed in the dependency metadata) call it to enforce line visibility during API operations. Because the package is not documented as a public API, customizations should not invoke it directly; instead, custom code should respect Order Management's supported APIs and the security configuration established through setup. Developers troubleshooting unexpected line visibility should examine the security rules stored in OE_PC_CONSTRAINTS and the profile options read via FND_PROFILE, as those drive the evaluations performed here.
-
View: M4R_3A6_OE_LINE_ACKS 12.2.2
View same as OE_LINE_ACKS, with one additional column MODEL_REFERENCE_TEXT
APPS.M4R_3A6_OE_LINE_ACKS·↳ OE_LINE_ACKS·↳ OE_ORDER_LINES_ALL·Explore CLN module →
-
View: OE_LINE_ACKS_V 12.1.1
Information about the acknowledgements for Order Lines
-
View: OE_LINE_ACKS_V 12.2.2
Information about the acknowledgements for Order Lines
-
View: M4R_3A6_OE_LINE_ACKS 12.1.1
View same as OE_LINE_ACKS, with one additional column MODEL_REFERENCE_TEXT
APPS.M4R_3A6_OE_LINE_ACKS·↳ OE_LINE_ACKS·↳ OE_ORDER_LINES_ALL·Explore CLN module →
-
View: ASO_I_OE_ORDER_LINES_V 12.1.1
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: OE_ORDER_LINES_HIST_V 12.1.1
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: ASO_I_OE_ORDER_LINES_V 12.2.2
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: OKX_ORDER_LINES_V 12.2.2
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
This table stores sales order demand and reservations from source application instances.
-
This table stores sales order demand and reservations from source application instances.
-
This is a multi-org table for sales order lines open interface.
-
View: OE_SCH_ORDER_LINES_V 12.2.2
APPS.OE_SCH_ORDER_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.1.1
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OKX_ORDER_LINES_V 12.1.1
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
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 →
-
View: OE_SCH_RSV_SET_LINES_V 12.2.2
View used by the new form for scheduling across orders with Reservation set information
APPS.OE_SCH_RSV_SET_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
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 →
-
View: OE_BLKT_LINES_HIST_V 12.1.1
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
This table stores information about the acknowledgements for Order Lines.
-
This table stores information about the acknowledgements for Order Lines.
-
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 →
-
The staging table used by the collection program to validate and process data for table MSC_SALES_ORDERS.
-
The staging table used by the collection program to validate and process data for table MSC_SALES_ORDERS.
-
Table to capture sales agreement lines history.
-
Table to capture sales agreement lines history.
-
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.2.2
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_SCH_RSV_SET_LINES_V 12.1.1
View used by the new form for scheduling across orders with Reservation set information
APPS.OE_SCH_RSV_SET_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
APPS.OE_BLANKET_LINES_HIST_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_SCH_ORDER_LINES_V 12.1.1
APPS.OE_SCH_ORDER_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_AK_ORDER_LINES_V 12.1.1
APPS.OE_AK_ORDER_LINES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
View: OE_AK_ORDER_LINES_V 12.2.2
APPS.OE_AK_ORDER_LINES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_LINES_ALL·Explore ONT module →
-
View: OE_ORDER_LINES_V 12.1.1
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 →
-
View: OE_BLKT_LINES_HIST_V 12.2.2
This view is used to get BSA history lines information, which is used in BSA organizer.
APPS.OE_BLKT_LINES_HIST_V·↳ MTL_GRADES·↳ MTL_PARAMETERS·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
Table to capture sales agreement Line details.(Attributes common between Sales Order and Sales Agreements).
-
Table to capture sales agreement Line details.(Attributes common between Sales Order and Sales Agreements).
-
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
-
Stores history of attribute change for Order Lines.
-
Stores history of attribute change for Order Lines.
-
This is a multi-org table for sales order lines open interface.
-
VIEW: MSC.MSC_SALES_ORDERS# 12.2.2