Results for “last_print_date”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
INVBV_KANBAN_CARD_ACTIVITIES is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Inventory (INV) product family. It is a "B" (base/backing) view, denoted by the "BV" naming convention, and presents kanban replenishment activity data for reporting and integration purposes. The view is documented in ETRM 12.2.2 as "Retrofitted," indicating it was added or recreated to support a specific functional requirement, typically layered security and lookup translation applied on top of an underlying transactional table. In EBS 12.1.1 and 12.2.2, this view surfaces a denormalized, presentation-ready projection of kanban card activity, with organization-level security enforced and several coded columns resolved to their display meanings. It is primarily consumed by Oracle Inventory forms, concurrent programs, and external integrations that need to query kanban activity without directly touching the base transaction table.
Underlying Base Objects
The view is defined over a single base object, MTL_KANBAN_CARD_ACTIVITY, referenced through a synonym (MTL_KANBAN_CARD_ACTIVITY). The view text aliases this table as MKA and selects its columns with no joins, making the view a straightforward projection with three notable behavioral characteristics. First, a WHERE clause of '_SEC:MKA.ORGANIZATION_ID' IS NOT NULL applies Multi-Org / MOAC security, restricting rows by the operating unit or organization context of the querying session. Second, several lookup columns are exposed using _LA (lookup attribute) aliases, which instruct the Oracle Forms / OA Framework translation layer to resolve codes against MFG_LOOKUPS. Third, the view is declared WITH READ ONLY, so no DML is permitted. Because the view references the base table directly, it inherits all organization partitioning and indexing of MTL_KANBAN_CARD_ACTIVITY.
Key Columns
- KANBAN_ACTIVITY_ID — Primary identifier for the kanban activity record.
- REPLENISHMENT_CYCLE_ID / KANBAN_CARD_ID / KANBAN_CARD_NUMBER — Identify the replenishment cycle and the specific kanban card involved.
- INVENTORY_ITEM_ID / ORGANIZATION_ID / SUBINVENTORY_NAME — Item and inventory location context; ORGANIZATION_ID drives MOAC security.
- "_LA:SUPPLY_STATUS", "_LA:CARD_STATUS", "_LA:KANBAN_CARD_TYPE", "_LA:SOURCE_TYPE" — Coded values resolved against MFG_LOOKUPS (MTL_KANBAN_SUPPLY_STATUS, MTL_KANBAN_CARD_STATUS, MTL_KANBAN_CARD_TYPE, MTL_KANBAN_SOURCE_TYPE respectively), returned as MEANING.
- KANBAN_SIZE / INVENTORY_LOCATOR_ID — Replenishment quantity and storage locator.
- SUPPLIER_ID / SUPPLIER_SITE_ID / SOURCE_ORGANIZATION_ID / SOURCE_SUBINVENTORY_NAME / SOURCE_INVENTORY_LOCATOR_ID — Source supply details for supplier, inter-org, or intra-org kanban.
- "_LA:DOCUMENT_TYPE" / DOCUMENT_HEADER_ID / DOCUMENT_DETAIL_ID — Related document (e.g., PO, requisition) resolved via MTL_KANBAN_DOCUMENT_TYPE.
- "_LA:ERROR_CODE" / LAST_PRINT_DATE — Processing error indicator and last card print timestamp.
- WIP_LINE_ID — Links the activity to a Work in Process line where applicable.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.
Common Use Cases and Queries
Typical uses include querying kanban activity for a specific organization, tracking card supply and status history, and feeding replenishment data into custom reports. The _LA aliases are meaningful to the OA Framework layer; direct SQL against the view returns the raw code values for those columns, so reports must join MFG_LOOKUPS explicitly for meanings.
Example: retrieve recent activity for an item and organization.
SELECT kanban_card_number,
subinventory_name,
kanban_size,
last_update_date
FROM apps.invbv_kanban_card_activities
WHERE organization_id = :org_id
AND inventory_item_id = :item_id
ORDER BY last_update_date DESC;
Example: summarize activity by card status.
SELECT card_status, COUNT(*) FROM apps.invbv_kanban_card_activities WHERE organization_id = :org_id GROUP BY card_status;
Because of the MOAC predicate, queries must run with a valid organization context, and callers should treat the view as strictly read-only.
-
- Retrofitted
APPS.INVBV_KANBAN_CARD_ACTIVITIES·↳ MTL_KANBAN_CARD_ACTIVITY·Explore INV module →
-
Table: MTL_EXT_OBJECTS 12.1.1
External component information of an inventory item
-
Table: MTL_EXT_OBJECTS 12.2.2
External component information of an inventory item
-
Major events that have occurred relevant to an object
-
- Retrofitted
APPS.INVBV_KANBAN_CARD_ACTIVITIES·↳ MTL_KANBAN_CARD_ACTIVITY·Explore INV module →
-
- Retrofitted
APPS.INVFV_KANBAN_CARD_ACTIVITIES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_KANBAN_CARD_ACTIVITY·Explore INV module →
-
View: ARBV_CREDITS 12.1.1
APPS.ARBV_CREDITS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
This shows information about credits that you assign to your customer's account that are not related to a specific invoice.
APPS.ARBV_ON_ACCOUNT_CREDIT_MEMOS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
View: INVBV_KANBAN_CARDS 12.1.1
- Retrofitted
APPS.INVBV_KANBAN_CARDS·↳ MTL_KANBAN_CARDS·Explore INV module →
-
Schedule headers table
-
- Retrofitted
APPS.MTL_KANBAN_CARD_ACTIVITY_V·↳ MFG_LOOKUPS·↳ MTL_KANBAN_CARD_ACTIVITY·Explore INV module →
-
View: ARBV_AR_TRANSACTIONS 12.1.1
This shows information about transactions imported from a foreign system into Oracle Receivables.
APPS.ARBV_AR_TRANSACTIONS·↳ RA_CUSTOMER_TRX·Explore AR module →
-
View: ARBV_INVOICE_ARS 12.1.1
- Retrofitted
APPS.ARBV_INVOICE_ARS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
Schedule headers table
-
Kanban Cards
-
used to select the schedule and vendor info
APPS.POS_CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore POS module →
-
View: MTL_KANBAN_CARDS_V 12.2.2
- Retrofitted
APPS.MTL_KANBAN_CARDS_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore INV module →
-
Used to select schedule and vendor info for shipment schedules.
APPS.ICX_SHIP_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
Used to select schedule and vendor info for planning schedules.
APPS.ICX_PLAN_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
View: INVBV_KANBAN_CARDS 12.2.2
- Retrofitted
APPS.INVBV_KANBAN_CARDS·↳ MTL_KANBAN_CARDS·Explore INV module →
-
View: INVFV_KANBAN_CARDS 12.1.1
- Retrofitted
APPS.INVFV_KANBAN_CARDS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·↳ MTL_KANBAN_CARDS·Explore INV module →
-
View: ARBV_AR_TRANSACTIONS 12.2.2
This shows information about transactions imported from a foreign system into Oracle Receivables.
APPS.ARBV_AR_TRANSACTIONS·↳ RA_CUSTOMER_TRX·Explore AR module →
-
View: ARBV_INVOICE_ARS 12.2.2
- Retrofitted
APPS.ARBV_INVOICE_ARS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
Major events that have occurred relevant to an object
-
View: ARFV_AR_TRANSACTIONS 12.2.2
This shows information about transactions imported from a foreign system into Oracle Receivables.
APPS.ARFV_AR_TRANSACTIONS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: ARFV_AR_TRANSACTIONS 12.1.1
This shows information about transactions imported from a foreign system into Oracle Receivables.
APPS.ARFV_AR_TRANSACTIONS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: INVFV_KANBAN_CARDS 12.2.2
- Retrofitted
APPS.INVFV_KANBAN_CARDS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·Explore INV module →
-
View: CHV_SCHEDULE_HEADERS_V 12.1.1
- Retrofitted
APPS.CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore CHV module →
-
Used to select schedule and vendor info for shipment schedules.
APPS.ICX_SHIP_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
- Retrofitted
APPS.MTL_KANBAN_CARD_ACTIVITY_V·↳ MFG_LOOKUPS·↳ MTL_KANBAN_CARD_ACTIVITY·Explore INV module →
-
View: ARBV_DEBITS 12.1.1
This shows information about items that increase your customer's receivable balance. Debit items remain open until the balance due is zero.
APPS.ARBV_DEBITS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
View: ARBV_CREDIT_MEMO_ARS 12.1.1
This shows information about credit memos. Credit memos are documents that partially or fully reverse an original invoice.
APPS.ARBV_CREDIT_MEMO_ARS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
View: ARBV_DEBITS 12.2.2
This shows information about items that increase your customer's receivable balance. Debit items remain open until the balance due is zero.
APPS.ARBV_DEBITS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
- Retrofitted
APPS.INVFV_KANBAN_CARD_ACTIVITIES·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MTL_ITEM_LOCATIONS·Explore INV module →
-
View: ARBV_CREDITS 12.2.2
APPS.ARBV_CREDITS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
View: ARFV_DEBITS 12.1.1
This shows information relating to items that increase your customer's receivable balance. Debit items remain open until the balance due is zero.
APPS.ARFV_DEBITS·↳ AR_RECEIPT_METHODS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_COMMON_PUB·Explore AR module →
-
View: ARFV_DEBITS 12.2.2
This shows information relating to items that increase your customer's receivable balance. Debit items remain open until the balance due is zero.
APPS.ARFV_DEBITS·↳ AR_RECEIPT_METHODS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AR module →
-
Kanban Cards
-
Used to select schedule and vendor info for planning schedules.
APPS.ICX_PLAN_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore ICX module →
-
APPS.POS_CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore PO module →
-
Used to select schedule and vendor info for planning schedules.
APPS.POS_PLAN_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore POS module →
-
This shows information about credits that you assign to your customer's account that are not related to a specific invoice.
APPS.ARBV_ON_ACCOUNT_CREDIT_MEMOS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
View: ARBV_CREDIT_MEMO_ARS 12.2.2
This shows information about credit memos. Credit memos are documents that partially or fully reverse an original invoice.
APPS.ARBV_CREDIT_MEMO_ARS·↳ RA_CUSTOMER_TRX·↳ RA_CUST_TRX_TYPES·Explore AR module →
-
View: ARFV_INVOICE_ARS 12.2.2
This shows information about an invoice. An invoice is a document that lists amounts owed for the purchase of goods or services.
APPS.ARFV_INVOICE_ARS·↳ AR_RECEIPT_METHODS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·Explore AR module →
-
Kanban Card Activity
-
Kanban Card Activity
-
View: CHV_SCHEDULE_HEADERS_V 12.2.2
- Retrofitted
APPS.CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore CHV module →
-
APPS.POS_CHV_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore PO module →
-
Used to select schedule and vendor info for shipment schedules.
APPS.POS_SHIP_SCHEDULE_HEADERS_V·↳ CHV_BUCKET_PATTERNS·↳ CHV_SCHEDULE_HEADERS·↳ FND_GLOBAL·Explore POS module →