FLM Purge Kanban

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Purge Kanban Pull Sequences
Application: Flow Manufacturing
Source: Purge Kanban (XML)
Short Name: FLMPKB_XML
DB package: FLM_FLMRFPKB_XMLP_PKG
Run FLM Purge Kanban and other Oracle EBS reports with Blitz Report™ on our demo environment
select fkp.organization_id,
       fkp.item_id,
       &P_ASSY_FLEX C_ITEM_FLEX,
       fkp.subinventory_code,
       fkp.locator_id,
       decode(nvl(fkp.locator_id,-1),-1,NULL,null) C_LOC_FLEX,
       fkp.type,
       decode(fkp.type,1,'Kanban Cards Purged',2,'Pull Sequences Purged',
                   3,'Exceptions in Purge') ttype,
       fkp.count, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('item_name', 'INV', 'MSTK', 101, MSI1.ORGANIZATION_ID, MSI1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_NAME, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('locator_name', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') LOCATOR_NAME
from   flm_kanban_purge_temp fkp,
       mtl_system_items msi1,
       mtl_item_locations mil
where  fkp.organization_id = msi1.organization_id
  and  fkp.item_id = msi1.inventory_item_id
  and  fkp.organization_id = mil.organization_id(+)
  and  nvl(fkp.locator_id,-1) = nvl(mil.inventory_location_id(+),-1)
  and fkp.group_id = :P_CONC_REQUEST_ID
order by fkp.type
Parameter Name SQL text Validation
Type 
 
 LOV Oracle
Item From 
 
 Char
To 
 
 Char
Subinventory From 
 
 LOV Oracle
To 2 
 
 LOV Oracle
Source Type 
 
 LOV Oracle
Line 
 
 LOV Oracle
Supplier 
 
 LOV Oracle
Organization 
 
 LOV Oracle
Subinventory 
 
 LOV Oracle
Delete Cards 
 
 LOV Oracle
Download
Related Blitz Reports
ECC Discrete Manufacturing, Work Orders FLM Flow Schedule INV Print Kanban Cards EAM Material Issue Request Pick List BOM Bill of Material Structure WIP Mass Return Components for Serialized Assembly CST Uninvoiced Receipts PO Receiving Value WSH Shipping/Delivery Transactions
Blitz Report™

Blitz Report™ provides multiple benefits: