Search Results okx_tax_codes_v
The OKL.OKL_TXL_AP_INV_LNS_ALL_B
table is a critical component within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically designed for the Oracle Lease and Finance Management (OKL) module. This table serves as the base table for storing transactional data related to invoice lines in the Accounts Payable (AP) integration process. It plays a pivotal role in managing lease-related financial transactions, ensuring seamless data flow between lease contracts and payable invoices.
Table Structure and Key Columns
The table structure comprises columns that capture essential attributes of invoice lines, including:- ID: Primary key identifier for the invoice line record.
- INVOICE_ID: References the parent invoice header in
OKL_TXL_AP_INV_HDRS_ALL_B
. - LINE_NUMBER: Sequential number identifying the line within an invoice.
- AMOUNT: Monetary value of the invoice line.
- CURRENCY_CODE: Currency in which the amount is denominated.
- DESCRIPTION: Textual description of the invoice line item.
- ASSET_ID: Optional reference to leased assets, linking to
OKL_ASSETS_B
. - CONTRACT_ID: Foreign key to
OKL_K_HEADERS_B
, associating the line with a lease contract. - CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Standard Oracle audit columns.
- OBJECT_VERSION_NUMBER: Used for optimistic locking in OAF pages.
Functional Role in Lease Management
This table acts as an intermediary between lease contracts (OKL_K_HEADERS_B
) and AP invoice lines (AP_INVOICE_LINES_ALL
). Key functionalities include:
- Lease Payment Processing: Captures line-level details of vendor invoices for lease-related payments (e.g., maintenance, insurance).
- Asset Cost Allocation: When invoice lines pertain to leased assets, the
ASSET_ID
enables cost tracking per asset. - Multi-Org Support: Includes
ORG_ID
for multi-organization access control. - Integration with AP Module: Data from this table feeds into Oracle Payables via interface tables like
AP_INVOICE_LINES_INTERFACE
.
Technical Considerations
- Indexes: Typically indexed on
ID
,INVOICE_ID
, andCONTRACT_ID
for performance. - Views: Often accessed through views like
OKL_TXL_AP_INV_LNS_ALL
which adds language-specific translations. - APIs: Modifications should use OKL public APIs rather than direct DML to maintain data integrity.
- Partitioning: In high-volume implementations, partitioning by
ORG_ID
or date ranges may be implemented.
Customization and Extension
The table supports flexfields for custom attributes:- Descriptive Flexfields (DFF): Allow adding context-sensitive fields.
- Key Flexfields (KFF): Rarely used on this table but configurable if needed.
Data Flow Example
A typical workflow involves:- Lease contract creation in OKL
- Vendor invoice entry via OKL screens
- Line details stored in
OKL_TXL_AP_INV_LNS_ALL_B
- Interface program transfers data to AP
- Payment processing in Payables
Version-Specific Notes
Between 12.1.1 and 12.2.2:- Column structure remains largely consistent
- 12.2.2 may include additional indexes for cloud-optimized performance
- Online patching (Edition-Based Redefinition) in 12.2.2 affects how updates are applied
-
View: OKX_TAX_CODES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKX.OKX_TAX_CODES_V, object_name:OKX_TAX_CODES_V, status:VALID, product: OKX - Contracts Integration , description: Tax codes , implementation_dba_data: APPS.OKX_TAX_CODES_V ,
-
View: OKX_TAX_CODES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKX.OKX_TAX_CODES_V, object_name:OKX_TAX_CODES_V, status:VALID, product: OKX - Contracts Integration , description: Tax codes , implementation_dba_data: APPS.OKX_TAX_CODES_V ,
-
APPS.OKL_TPL_PVT dependencies on OKX_TAX_CODES_V
12.2.2
-
APPS.OKL_TPL_PVT dependencies on OKX_TAX_CODES_V
12.1.1
-
SYNONYM: APPS.AR_VAT_TAX_ALL_TL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_VAT_TAX_ALL_TL, status:VALID,
-
SYNONYM: APPS.AR_VAT_TAX_ALL_TL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_VAT_TAX_ALL_TL, status:VALID,
-
PACKAGE BODY: APPS.OKL_TPL_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_TPL_PVT, status:VALID,
-
PACKAGE BODY: APPS.OKL_TPL_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_TPL_PVT, status:VALID,
-
SYNONYM: APPS.AR_VAT_TAX_ALL_B
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AR_VAT_TAX_ALL_B, status:VALID,
-
SYNONYM: APPS.AR_VAT_TAX_ALL_B
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AR_VAT_TAX_ALL_B, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.1.1 FND Design Data
12.1.1
-
12.2.2 FND Design Data
12.2.2
-
APPS.OKS_ENTITLEMENTS_WEB dependencies on OKS_K_LINES_B
12.2.2
-
APPS.OKS_ENTITLEMENTS_WEB dependencies on OKS_K_LINES_B
12.1.1
-
VIEW: APPS.OKX_TAX_CODES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKX.OKX_TAX_CODES_V, object_name:OKX_TAX_CODES_V, status:VALID,
-
VIEW: APPS.OKX_TAX_CODES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKX.OKX_TAX_CODES_V, object_name:OKX_TAX_CODES_V, status:VALID,
-
VIEW: APPS.OKL_TXL_AP_INV_LNS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKL.OKL_TXL_AP_INV_LNS_V, object_name:OKL_TXL_AP_INV_LNS_V, status:VALID,
-
APPS.OKL_TPL_PVT dependencies on OKL_TXL_AP_INV_LNS_V
12.2.2
-
TABLE: OKL.OKL_TXL_AP_INV_LNS_ALL_B
12.2.2
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_TXL_AP_INV_LNS_ALL_B, object_name:OKL_TXL_AP_INV_LNS_ALL_B, status:VALID,
-
TABLE: OKL.OKL_TXL_AP_INV_LNS_ALL_B
12.1.1
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_TXL_AP_INV_LNS_ALL_B, object_name:OKL_TXL_AP_INV_LNS_ALL_B, status:VALID,
-
APPS.OKL_TPL_PVT dependencies on OKL_TXL_AP_INV_LNS_V
12.1.1
-
VIEW: APPS.OKL_TXL_AP_INV_LNS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKL.OKL_TXL_AP_INV_LNS_V, object_name:OKL_TXL_AP_INV_LNS_V, status:VALID,
-
APPS.OKL_TPL_PVT SQL Statements
12.2.2
-
APPS.OKL_TPL_PVT SQL Statements
12.1.1
-
APPS.OKS_ENTITLEMENTS_WEB SQL Statements
12.1.1
-
APPS.OKS_ENTITLEMENTS_WEB SQL Statements
12.2.2
-
eTRM - OKX Tables and Views
12.2.2
-
eTRM - OKX Tables and Views
12.1.1
-
PACKAGE BODY: APPS.OKS_ENTITLEMENTS_WEB
12.2.2
-
PACKAGE BODY: APPS.OKS_ENTITLEMENTS_WEB
12.1.1
-
PACKAGE BODY: APPS.OKL_TPL_PVT
12.2.2
-
PACKAGE BODY: APPS.OKL_TPL_PVT
12.1.1
-
12.2.2 DBA Data
12.2.2
-
APPS.OKL_TPL_PVT dependencies on OKL_API
12.1.1
-
APPS.OKL_TPL_PVT dependencies on OKL_API
12.2.2
-
12.1.1 DBA Data
12.1.1
-
eTRM - OKX Tables and Views
12.1.1
-
eTRM - OKX Tables and Views
12.2.2
-
eTRM - OKL Tables and Views
12.2.2
description: Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards ,
-
eTRM - OKL Tables and Views
12.1.1
description: Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards ,