APPS.FLM_KANBAN_PURGE dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 26: MTL_KANBAN_PULL_SEQUENCES . The above mentioned procedures are

22:
23: Purge_Kanban - This is the main procedure and is called from the
24: report with the user parameters. This has a cursor to pick up
25: the eligible information for the Purge from the main table
26: MTL_KANBAN_PULL_SEQUENCES . The above mentioned procedures are
27: called for every record in the curor.
28: */
29:
30: PROCEDURE PURGE_KANBAN_CARDS(

Line 195: FROM MTL_KANBAN_PULL_SEQUENCES

191: into l_records_found
192: FROM DUAL
193: WHERE EXISTS
194: ( SELECT 1
195: FROM MTL_KANBAN_PULL_SEQUENCES
196: WHERE organization_id = arg_org_id
197: AND source_organization_id = organization_id
198: AND inventory_item_id = arg_item_id
199: AND source_subinventory = arg_subinv

Line 244: DELETE MTL_KANBAN_PULL_SEQUENCES

240: end if;
241:
242: l_stmt_num := 350;
243:
244: DELETE MTL_KANBAN_PULL_SEQUENCES
245: WHERE organization_id = arg_org_id
246: AND inventory_item_id = arg_item_id
247: AND subinventory_name = arg_subinv
248: AND nvl(locator_id,-1) = nvl(arg_loc_id,-1) ;

Line 302: from mtl_kanban_pull_sequences

298: that all the unreferenced pull sequences are deleted in a single loop*/
299: CURSOR Cur_Kanban(source in number,item_id in number,in_subinv in varchar2) is
300: Select pull_sequence_id,inventory_item_id,
301: subinventory_name,locator_id
302: from mtl_kanban_pull_sequences
303: where organization_id = arg_org_id
304: and inventory_item_id = item_id
305: and subinventory_name <= nvl(arg_subinv_from,subinventory_name)
306: and subinventory_name >= nvl(arg_subinv_to,subinventory_name)

Line 351: which do not form a chain in the mtl_kanban_pull_sequences.

347: MRP_UTIL.MRP_LOG('Supplier-id --> '||to_char(arg_supplier_id));
348: MRP_UTIL.MRP_LOG('Delete Card --> '||to_char(arg_delete_card));
349:
350: /* This is the first cursor which will pick up all those sequences
351: which do not form a chain in the mtl_kanban_pull_sequences.
352: (i.e) If there are 2 pull sequences which form a chain because the
353: source-subinventory is the supply sub-inventory for the next then
354: only the last in chain will be picked up in this cursor */
355:

Line 360: ' FROM mtl_kanban_pull_sequences MKP1'||

356: l_sql_p := dbms_sql.open_cursor;
357: l_sql_stmt :=
358: 'SELECT pull_sequence_id, inventory_item_id,'||
359: 'subinventory_name, locator_id'||
360: ' FROM mtl_kanban_pull_sequences MKP1'||
361: ' WHERE mkp1.organization_id = :org_id'||
362: ' AND mkp1.subinventory_name >= nvl(:sub_from, subinventory_name)'||
363: ' AND mkp1.subinventory_name <= nvl(:sub_to, subinventory_name)'||
364: ' AND mkp1.kanban_plan_id = -1'||

Line 384: ' mtl_kanban_pull_sequences mkp2' ||

380:
381: l_sql_stmt := l_sql_stmt || ' AND ' ||
382: ' NOT EXISTS (' ||
383: ' SELECT 1 FROM ' ||
384: ' mtl_kanban_pull_sequences mkp2' ||
385: ' where mkp2.inventory_item_id = mkp1.inventory_item_id '||
386: ' and mkp2.source_subinventory = mkp1.subinventory_name '||
387: ' and mkp2.source_organization_id = mkp2.organization_id '||
388: ' and mkp2.subinventory_name >= nvl(:sub_from,mkp2.subinventory_name) '||