Results for “dep_plan_required_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_AK_DEP_PLAN_REQD_V is a lightweight Oracle EBS view owned by the APPS schema and registered under the ONT (Order Management) product family. Despite its association with Order Management, the view is a generic lookup utility rather than a transactional order entity. Its sole purpose is to expose the seeded YES_NO lookup values from the FND_LOOKUPS foundation table, providing a controlled enumeration of valid "Yes"/"No" indicator codes for use throughout the E-Business Suite.
Within Oracle EBS 12.1.1 and 12.2.2, lookup-based validation is a core design pattern. Rather than hard-coding allowed values, Oracle stores configurable lists in FND_LOOKUPS and exposes them through narrowly scoped views such as this one. This abstraction means the set of returned rows is governed entirely by the lookup configuration in the application, not by any order-specific business logic. As a result, the view supports reporting, concurrent programs, Oracle Forms LOVs, OA Framework pages, and interface/API validation logic that must confirm a flag is either "Y" or "N" (or the enabled Yes/No codes defined for the instance). Its status is VALID in the documented metadata, confirming the object is compiled and queryable.
Underlying Base Objects
The ETRM metadata identifies two referenced base objects:
- FND_LOOKUPS (VIEW) — the single data source named in the view's SELECT statement. FND_LOOKUPS is the runtime view over the lookup dictionary, and this development view selects from it with a fixed filter on
LOOKUP_TYPE = 'YES_NO'. - FND_GLOBAL (PACKAGE) — referenced indirectly and typically invoked for session context functions such as
FND_GLOBAL.USER_ID,FND_GLOBAL.RESP_ID, orFND_GLOBAL.LANG. Because lookups are language-sensitive, the effective language context supplied by FND_GLOBAL governs which translated description rows are returned.
The view defined in the documentation extracts the LOOKUP_CODE column from FND_LOOKUPS. The dependency on FND_LOOKUPS is therefore direct and read-only; no DML is performed through this object.
Key Columns
- DEP_PLAN_REQUIRED_FLAG — the documented column exposed by the view. It returns the enabled
LOOKUP_CODEvalues for theYES_NOlookup type, i.e., the codes representing Yes/No selections. In practice these resolve to values such as "Y" and "N".
Because the view text projects only LOOKUP_CODE, no descriptions, meanings, or tag columns are surfaced. Consumers requiring translated display text must join to FND_LOOKUPS or FND_LOOKUPS_TL themselves or query the lookup tables directly.
Common Use Cases and Queries
Typical scenarios include LOV population, Boolean-style flag validation in order interface programs, and report parameter domains. A representative query is:
SELECT DEP_PLAN_REQUIRED_FLAG FROM APPS.OE_AK_DEP_PLAN_REQD_V;— returns all enabled Yes/No codes.SELECT DEP_PLAN_REQUIRED_FLAG FROM APPS.OE_AK_DEP_PLAN_REQD_V WHERE DEP_PLAN_REQUIRED_FLAG = 'Y';— isolates the affirmative code.- Embedding the view inside a validation package to reject values outside the configured Yes/No set.
Because the view returns a small, static set of lookup codes, it carries negligible performance overhead. Its value lies in enforcing consistent, configuration-driven Yes/No handling across Order Management extensions and integrations in both 12.1.1 and 12.2.2 environments.
-
View: OE_AK_DEP_PLAN_REQD_V 12.1.1
APPS.OE_AK_DEP_PLAN_REQD_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore ONT module →
-
View: WSH_PICKING_UPGRADE_V 12.1.1
APPS.WSH_PICKING_UPGRADE_V·↳ SO_PICKING_LINES_ALL·↳ SO_PICKING_LINE_DETAILS·↳ WSH_DEPARTURES·Explore WSH module →
-
View: SO_PICKING_LINES 12.2.2
10SC ONLY
APPS.SO_PICKING_LINES·↳ SO_PICKING_LINES_ALL·Explore OE module →
-
View: OE_AK_DEP_PLAN_REQD_V 12.2.2
APPS.OE_AK_DEP_PLAN_REQD_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·Explore ONT module →
-
Customer item Information
-
View: OE_AK_MTL_CUST_ITEMS_V 12.1.1
APPS.OE_AK_MTL_CUST_ITEMS_V·↳ MTL_CUSTOMER_ITEMS·Explore ONT module →
-
View: OE_AK_MTL_CUST_ITEMS_V 12.2.2
APPS.OE_AK_MTL_CUST_ITEMS_V·↳ MTL_CUSTOMER_ITEMS·Explore ONT module →
-
Sales Order upgrade table - Shipping integration.
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
View: SO_LINE_DETAILS_V 12.1.1
APPS.SO_LINE_DETAILS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_PARAMETERS·Explore OE module →
-
Order line schedule details
-
View: WSH_PICKING_UPGRADE_V 12.2.2
APPS.WSH_PICKING_UPGRADE_V·↳ SO_PICKING_LINES_ALL·↳ SO_PICKING_LINE_DETAILS·↳ WSH_DEPARTURES·Explore WSH module →
-
View: OE_CRM_ORDER_LINES_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·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: SO_PICKING_LINES 12.1.1
10SC ONLY
APPS.SO_PICKING_LINES·↳ SO_PICKING_LINES_ALL·Explore OE module →
-
APPS.WSH_DLVY_DELIVERABLES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOOKUPS·Explore WSH module →
-
View: WSH_DELIVERABLES_V 12.1.1
APPS.WSH_DELIVERABLES_V·↳ FND_LOOKUP_VALUES·↳ WMS_LICENSE_PLATE_NUMBERS·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH module →
-
Customer item Information
-
View: OE_DELIVERY_LINES_V 12.2.2
This view is for interfacing the lines to shipping, for departure planning.
APPS.OE_DELIVERY_LINES_V·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS·↳ OE_ORDER_HEADERS_ALL·Explore ONT 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 →
-
Sales Order upgrade table - Shipping integration.
-
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 →
-
Picking lines
-
Picking lines
-
APPS.WSH_TRIP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_TRIPS·Explore WSH 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_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 →
-
View: OE_DELIVERY_LINES_V 12.1.1
This view is for interfacing the lines to shipping, for departure planning.
APPS.OE_DELIVERY_LINES_V·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS·↳ OE_ORDER_HEADERS_ALL·Explore ONT module →
-
10SC ONLY
APPS.MTL_CUSTOMER_ITEMS_ALL_V·↳ ARP_ADDR_PKG·↳ AR_LOOKUPS·↳ FND_TERRITORIES_VL·Explore INV module →
-
10SC ONLY
APPS.MTL_CUSTOMER_ITEMS_ALL_V·↳ ARP_ADDR_PKG·↳ AR_LOOKUPS·↳ FND_TERRITORIES_VL·Explore INV module →
-
Delivery Detail interface Table
-
APPS.JAI_OM_WSH_DELIVERIES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_NEW_DELIVERIES·Explore JA module →
-
View: WSH_DEL_DTL_ASSGN_V 12.1.1
APPS.WSH_DEL_DTL_ASSGN_V·↳ WSH_DEL_ASSGN_INTERFACE·↳ WSH_DEL_DETAILS_INTERFACE·Explore WSH module →
-
View: OE_CRM_ORDER_LINES_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ONT module →
-
Customer Items Interface
-
APPS.WSH_STOP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_NEW_DELIVERIES·Explore WSH 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 →
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
APPS.WSH_TRIP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_TRIPS·Explore WSH module →
-
APPS.WSH_DLVY_DELIVERABLES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOOKUPS·Explore WSH module →
-
View: WSH_DELIVERABLES_V 12.2.2
APPS.WSH_DELIVERABLES_V·↳ FND_LOOKUP_VALUES·↳ WMS_LICENSE_PLATE_NUMBERS·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH 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).
-
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_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_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.2.2
APPS.OE_AK_ORDER_LINES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_LINES_ALL·Explore ONT module →