APPS.WIP_BIS_UTZ_ALERT dependencies on WIP_BIS_UTZ_CAT_V

Line 149: p_from := 'wip_bis_utz_cat_v';

145: p_select_product := 'TEMP.category_id ';
146: p_from := 'wip_bis_utz_catnoitem_v';
147: elsif dimension2_level = 3 then
148: p_select_product := 'TEMP.inventory_item_id ';
149: p_from := 'wip_bis_utz_cat_v';
150: end if;
151: p_groupby_product := p_select_product;
152:
153:

Line 379: FROM wip_bis_utz_cat_v

375: l_prod_level := 'ITEM';
376: END IF;
377: IF(dimension2_level >= 3) THEN
378: SELECT MAX(inventory_item_id) INTO l_item_id
379: FROM wip_bis_utz_cat_v
380: WHERE category_name = prod AND inventory_item_name = item;
381: END IF;
382:
383: l_param := 'P_PARAM_FROM_DATE=' ||

Line 687: p_from := 'wip_bis_utz_cat_v';

683: p_select_prod_name := 'TEMP.category_name ';
684: p_select_item_name := 'TEMP.inventory_item_name ';
685: p_groupby_product := 'TEMP.category_id, TEMP.inventory_item_id, ' ||
686: 'TEMP.category_name, TEMP.inventory_item_name';
687: p_from := 'wip_bis_utz_cat_v';
688: p_context_prod := 'ITEM';
689: p_where_trgt_prod := 'and trgt.dim2_level_value_id = to_char(TEMP.inventory_item_id) ';
690: end if;
691: