APPS.GMPMRRP dependencies on IC_WHSE_INV

Line 637: FROM ic_whse_inv

633: PROCEDURE mr_get_safety_stock(V_item_id NUMBER) IS
634:
635: CURSOR Cur_unit_safety_stock(C_item_id NUMBER) IS
636: SELECT safety_stock
637: FROM ic_whse_inv
638: WHERE item_id= C_item_id
639: AND whse_code is NULL and delete_mark=0;
640:
641:

Line 649: ' FROM ic_whse_inv'||

645: cur_sstock NUMBER;
646: BEGIN
647:
648: X_select1 :='SELECT sum(safety_stock) total_ss,count(*) no_ss'||
649: ' FROM ic_whse_inv'||
650: ' WHERE item_id = to_char(:1) ' ||
651: ' AND whse_code in ( ' || G_whse_list || ' ) ' ||
652: ' AND delete_mark=0 ';
653: