Search Results asset_tax_code

Overview

CE_RECEIVABLE_ACTIVITIES_V is a Reporting and Integration view owned by the APPS schema within the Cash Management (CE) module of Oracle E-Business Suite, documented as retrofitted through release 12.2.2. The view presents a filtered, operational list of Receivables activities specifically restricted to two transaction types: miscellaneous cash receipts (MISCCASH) and bank error transactions (BANK_ERROR). In the Cash Management flow, these activity types are used to record non-standard cash movements — bank-initiated corrections and miscellaneous cash deposits — that must be reconciled against bank statements without a corresponding customer invoice.

Because the view applies the current organizational access check through MO_GLOBAL and dynamically evaluates effective date ranges against SYSDATE, it functions as a security-aware, point-in-time reference for downstream reporting, validation list-of-values, and integration interfaces. Its presence in the ETRM metadata and retrofitted status confirms it is a supported object in both 12.1.1 and 12.2.2 environments.

Underlying Base Objects

The view is defined over two documented dependencies:

• AR_RECEIVABLES_TRX (SYNONYM) — The Receivables activities base table, referenced via the alias ART. All columns projected by the view originate from this table.
• MO_GLOBAL (PACKAGE) — The multi-org access control package, referenced only for its CHECK_ACCESS function within the WHERE clause.

No joins, aggregations, or additional tables are involved. The view is therefore a straightforward filtered projection rather than a denormalized reporting structure, which means it inherits the row-level attributes of AR_RECEIVABLES_TRX directly.

Key Columns

• RECEIVABLES_TRX_ID — Primary key of the underlying Receivables activity record; used as the foreign key reference in Cash Management transaction lines.
• NAME — The user-defined activity name, typically displayed in LOVs and reconciliation screens.
• DESCRIPTION — Descriptive text for the activity.
• SET_OF_BOOKS_ID — Identifies the ledger to which the activity belongs, enabling ledger-specific filtering.
• ASSET_TAX_CODE — The asset tax code associated with the Receivables activity, relevant to tax accounting treatment.
• ORG_ID — Operating unit identifier, essential for multi-org partitioning and reporting by organization.

Common Use Cases and Queries

The view is commonly used to populate activity list-of-values in Cash Management reconciliation windows, to validate activity availability during bank statement import, and to drive operational reports that require only currently active miscellaneous cash and bank error activities. Because the view enforces MO_GLOBAL.CHECK_ACCESS on ORG_ID, queries automatically return only organizations the current user may access.

A typical query retrieves active activities for the current organization context:

• SELECT receivables_trx_id, name, description, set_of_books_id, org_id FROM apps.ce_receivable_activities_v WHERE org_id = :p_org_id ORDER BY name;

For ledger-level validation, a report may join the view to GL ledger tables on SET_OF_BOOKS_ID. Since the view already filters inactive records (STATUS other than 'A') and expired date ranges, consumers need not repeat those predicates. Note that the SYSDATE-based date filtering means results change over time, so integrations should re-execute the view rather than caching results persistently.