FLM Purge Kanban

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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