DBA Data[Home] [Help]

APPS.FLM_KANBAN_PURGE dependencies on INVKBCGN

Line 374: INVKBCGN.query_range_itm(arg_item_from, arg_item_to,l_where_item);

370: ' OR ((mkp1.source_type = :source) AND (mkp1.source_type = 3) and (mkp1.source_subinventory = nvl(:source_subinv, mkp1.source_subinventory) ))'||
371: ' OR ((mkp1.source_type = :source) AND (mkp1.source_type = 4) and nvl(mkp1.wip_line_id, -1) = nvl(:line_id, nvl(mkp1.wip_line_id ,-1)) )))';
372:
373: if ((arg_item_from IS NOT NULL) or (arg_item_to IS NOT NULL)) then
374: INVKBCGN.query_range_itm(arg_item_from, arg_item_to,l_where_item);
375: l_sql_stmt := l_sql_stmt || ' AND ' ||
376: ' inventory_item_id in '||
377: ' (select inventory_item_id from mtl_system_items ' ||
378: ' where ' || l_where_item || ' and organization_id = :org_id) ';