Results for “packing_instructions”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_AK_PACK_INST_V is a view owned by the APPS schema within the Oracle E-Business Suite Order Management (ONT) module. In the documented metadata for ETRM 12.2.2 it carries a status of VALID and is referenced as a public-facing database object used by Oracle Order Management reporting and integration components. The object name follows the OE prefix common to Order Management tables and the AK prefix associated with Oracle's Application Kit or attribute/key flexfield generation utilities, suggesting it originates as a generated or thin compatibility view rather than a fully normalized reporting entity.
The view itself exposes only a single column, PACKING_INSTRUCTIONS, and its defining query is the minimal statement SELECT 1 FROM DUAL. This is a structurally significant detail: the view does not project data from any transactional or setup table. Instead it returns a constant literal value for every row produced by the DUAL synonym. In practical terms, OE_AK_PACK_INST_V functions as a placeholder or stub view rather than a data-bearing object.
Underlying Base Objects
The documented metadata lists DUAL (accessed via SYNONYM) as the sole referenced base object. DUAL is the standard Oracle single-row pseudo-table containing one row and one column. Because the view text is SELECT 1 FROM DUAL, the view definition does not join to OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, WSH_PACKING_INSTRUCTIONS, or any other Order Management or Shipping table that one might expect given the view name and the PACKING_INSTRUCTIONS column.
There is no documented dependency on a packing instructions setup table. The view therefore does not inherit upstream data, constraints, or foreign key relationships. It is defined entirely over DUAL and returns a fixed literal.
Key Columns
The only documented column is PACKING_INSTRUCTIONS. In a fully implemented packing instructions model, this column would typically carry descriptive text or a code identifying a packing rule — for example instructions specifying how items should be packaged, labeled, or grouped for shipment. In OE_AK_PACK_INST_V, however, the value returned is not sourced from a table column. Because the select list is the literal constant 1, every row exposed by the view reports PACKING_INSTRUCTIONS as the numeric value 1, irrespective of order, shipment, or item context.
Consumers should therefore treat the column as non-informative in this release. It cannot be used to drive conditional logic, decode packing behavior, or validate setup data, since it does not vary by any attribute.
Common Use Cases and Queries
Given the constant-valued definition, OE_AK_PACK_INST_V is best understood as a compatibility or scaffold object that satisfies a naming or column reference required by generated code, an Application Kit metadata definition, or a validation query. It is not a suitable source for operational packing instruction reporting.
A basic verification query returns the single constant row:
- SELECT PACKING_INSTRUCTIONS FROM APPS.OE_AK_PACK_INST_V;
- SELECT * FROM APPS.OE_AK_PACK_INST_V WHERE PACKING_INSTRUCTIONS = 1;
Because only one row results, predicates and joins add no analytic value. For genuine packing instruction data on 12.1.1 or 12.2.2, practitioners should query the actual Order Management and Shipping setup tables such as WSH_PACKING_INSTRUCTIONS and their associated Order Management linkage tables, and treat OE_AK_PACK_INST_V strictly as a documented stub with no substantive content.
-
View: OE_AK_PACK_INST_V 12.1.1
-
View: OE_AK_PACK_INST_V 12.2.2
-
PACKAGE: APPS.OE_VALIDATE 12.1.1
-
PACKAGE: APPS.OE_VALIDATE 12.2.2
-
View: OKX_QTE_SHIPMENTS_V 12.2.2
APPS.OKX_QTE_SHIPMENTS_V·↳ ASO_SHIPMENTS·Explore OKX module →
-
View: WMS_WP_LINES_GTMP_V 12.2.2
APPS.WMS_WP_LINES_GTMP_V·↳ WMS_WP_LINES_GTMP·Explore WMS module →
-
View: WSH_OPSM_ASN_ITEMS_V 12.2.2
APPS.WSH_OPSM_ASN_ITEMS_V·↳ WSH_OPSM_ASN_ITEMS_COMM_V·↳ WSH_OPSM_ASN_ITEMS_SPECIFIC_V·Explore WSH module →
-
View: OE_CRM_ORDER_HEADERS_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: OE_CRM_ORDER_HEADERS_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: WSH_SS_CONTAINERS_V 12.1.1
APPS.WSH_SS_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: OKX_QTE_SHIPMENTS_V 12.1.1
APPS.OKX_QTE_SHIPMENTS_V·↳ ASO_SHIPMENTS·Explore OKX module →
-
View: WSH_STND_CONTAINERS_V 12.2.2
APPS.WSH_STND_CONTAINERS_V·↳ FND_ID_FLEX_STRUCTURES_VL·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·Explore WSH module →
-
View: WSH_SS_SHIPITEMS_V 12.2.2
APPS.WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ASO module →
-
View: WSH_ITM_CONTAINERS_V 12.2.2
Temporary Table to return WSH_SS_CONTAINERS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_CONTAINERS_V·↳ HR_LOCATIONS_ALL_TL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_STND_SHIPITEMS_V 12.2.2
APPS.WSH_STND_SHIPITEMS_V·↳ FND_ID_FLEX_STRUCTURES_VL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·Explore WSH module →
-
This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ASO module →
-
View: CLN_WSH_SS_SHIPITEMS_V 12.1.1
View of delivery line details
APPS.CLN_WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore CLN module →
-
View: WSH_ITM_SHIPITEMS_V 12.2.2
Temporary Table to return WSH_SS_SHIPITEMS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: OE_PRN_ORDER_HEADERS_V 12.2.2
APPS.OE_PRN_ORDER_HEADERS_V·↳ FND_CURRENCIES_TL·↳ FND_CURRENCY·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
APPS.WSH_OPSM_ASN_ITEMS_COMM_V·↳ MTL_COMMODITY_CODES·↳ MTL_CROSS_REFERENCES_VL·↳ MTL_CUSTOMER_ITEMS·Explore WSH module →
-
View: SO_HEADERS_INTERFACE 12.1.1
APPS.SO_HEADERS_INTERFACE·↳ SO_HEADERS_INTERFACE_ALL·Explore OE 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 →
-
View: SO_HEADERS 12.2.2