INV Kanban Card Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Creates kanban cards for existing pull sequences and updates the size, card status, supply status and descriptive flexfield of kanban cards, as the Kanban Cards window (Inventory > Kanban > Kanban Cards).

A new card takes its source from the pull sequence of its item, subinventory and locator; leave Card Number blank to have it generated. Card and supply status changes follow the status transitions the form allows, and a supply status of Empty triggers the replenishment of the card.

Cards can be deleted with Delete Card.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Organization Code, Item, Subinventory, Card Status, Supply Status

Oracle EBS Tables Used

mtl_item_locations_kfv, ap_suppliers, ap_supplier_sites_all, mtl_parameters, wip_lines, mtl_kanban_cards, mtl_system_items_vl, org_access_view

Report Categories

Enginatics, R12 only, Upload

INV Kanban Cards, INV Items, INV Onhand Quantities, GL Account Distribution Analysis, PO Receiving Transactions, INV Move Orders, PO Headers and Lines, PO Approved Supplier List Upload, GL Account Analysis

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import INV_Kanban_Card_Upload.xml
SQL Source INV Kanban Card Upload.sql
Full Report on Enginatics www.enginatics.com/reports/inv-kanban-card-upload/

© Enginatics GmbH