FLM Purge Kanban

Description
Categories: BI Publisher, Manufacturing
Application: Flow Manufacturing
Source: Purge Kanban (XML)
Short Name: FLMPKB_XML
DB package: FLM_FLMRFPKB_XMLP_PKG
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
FLM_SRS_ORGANIZATION_RANGE_DUMMY
 
Number
FLM_KANBAN_SUPPLIER_DUMMY
 
Number
FLM_SRS_LINES_ID_DUMMY
 
Number
Organization_id
 
Number
Delete Cards
 
LOV Oracle
Subinventory
 
LOV Oracle
Organization
 
LOV Oracle
Supplier
 
LOV Oracle
Line
 
LOV Oracle
Source Type
 
LOV Oracle
To
 
LOV Oracle
Subinventory From
 
LOV Oracle
To
 
Item From
 
Type
 
LOV Oracle
Ask a question