Results for “invoicing_credit_method_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OE_AK_LINE_TYPES_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, registered under the ONT (Order Management) product family. It is a validation view generated in the Oracle Application Framework (OA Framework / "AK") naming convention, exposing the descriptive attributes of order line types so that they can be surfaced to end-user LOVs, flexfield validation, and integration layers without direct access to the underlying order management tables. The view occupies the same conceptual role as OE_LINE_TYPES_V: it answers the question "what default sourcing and fulfillment behavior is attached to a given order line type?".

Because the view is defined in APPS and carries the PUBLIC synonym and grants typical of ONT dictionary objects, it is safe to query from custom reports, BI Publisher data templates, Oracle Analytics, and third-party integration platforms. It is a thin projection, not a denormalization: no aggregation, no joins beyond its single base object, and no security predicates are added by the view itself, so row-level access is governed entirely by the grants on the base view.

Underlying Base Objects

The documented metadata lists a single referenced base object: OE_LINE_TYPES_V (a VIEW). The view text is a straightforward column projection over that base view alias B, with no WHERE clause and no outer joins:

SELECT B.TRANSACTION_TYPE_ID, B.ORDER_CATEGORY_CODE, B.PRICE_LIST_ID, B.WAREHOUSE_ID, B.DEMAND_CLASS_CODE, B.SHIPMENT_PRIORITY_CODE, B.SHIPPING_METHOD_CODE, B.FREIGHT_TERMS_CODE, B.FOB_POINT_CODE, B.AGREEMENT_TYPE_CODE, B.INVOICING_RULE_ID, B.INVOICING_CREDIT_METHOD_CODE, B.ACCOUNTING_RULE_ID, B.ACCOUNTING_CREDIT_METHOD_CODE, B.SHIP_SOURCE_TYPE_CODE FROM OE_LINE_TYPES_V B

The practical implication is that OE_AK_LINE_TYPES_V inherits all of the filter and translation behavior of OE_LINE_TYPES_V, which itself resolves down to the OE_TRANSACTION_TYPES_TL / OE_TRANSACTION_TYPES_B and related defaulting tables. Any performance or completeness characteristic observed on OE_LINE_TYPES_V applies equally here; there is no additional cost introduced by the wrapper.

Key Columns

• LINE_TYPE_ID — Identifier of the order line type. Note that the projected select list aliases TRANSACTION_TYPE_ID, so the effective key exposed to consumers is the transaction type identifier.
• ORDER_CATEGORY_CODE — Distinguishes order categories (for example order versus return), driving which downstream defaulting rules apply.
• PRICE_LIST_ID — Default price list assigned to the line type.
• SHIP_FROM_ORG_ID / WAREHOUSE_ID — Default ship-from organization; this is the column that determines the originating warehouse for fulfillment.
• SHIP_SOURCE_TYPE_CODE — The sourcing rule indicator requested in the user's search. It controls whether the line is sourced from a warehouse, from an outside supplier (drop-ship), or from another internal source, and is the primary column Order Management uses to route the line into the correct shipping and procurement flow.
• DEMAND_CLASS_CODE, SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD_CODE — Fulfillment defaults applied at order entry.
• FREIGHT_TERMS_CODE, FOB_POINT_CODE — Commercial shipping terms used in pricing and invoicing.
• AGREEMENT_TYPE_CODE — Default agreement/blanket vehicle for the line type.
• INVOICING_RULE_ID, INVOICING_CREDIT_METHOD_CODE, ACCOUNTING_RULE_ID, ACCOUNTING_CREDIT_METHOD_CODE — Revenue and receivables defaulting controls that determine when the line becomes invoiceable and how credits are handled.

Common Use Cases and Queries

Typical uses include validating that a line type is configured for the intended sourcing path before enabling drop-ship, building an order-entry defaulting matrix report, and feeding integration layers that must replicate ONT setup into middleware.

• Inspect sourcing configuration for all line types:

SELECT line_type_id, order_category_code, ship_from_org_id, ship_source_type_code, shipping_method_code FROM oe_ak_line_types_v;

• Find line types configured for a specific sourcing model:

SELECT line_type_id, order_category_code, ship_source_type_code, warehouse_id FROM oe_ak_line_types_v WHERE ship_source_type_code = :p_source_type;

• Reconcile invoicing and accounting defaults across categories:

SELECT line_type_id, order_category_code, invoicing_rule_id, invoicing_credit_method_code, accounting_rule_id, accounting_credit_method_code FROM oe_ak_line_types_v ORDER BY order_category_code, line_type_id;

Consumers should always join back to OE_TRANSACTION_TYPES_TL for the translated line type name, since OE_AK_LINE_TYPES_V exposes only codes and identifiers.