APPS.GMPMRACT dependencies on IC_WHSE_INV

Line 501: -- to get safety_stock from ic_whse_inv

497:
498: -- to get balance
499: IF G_whse_list IS NOT NULL THEN
500: mr_get_balance(V_item_id) ; /* Procedure to get the On Hand Qty */
501: -- to get safety_stock from ic_whse_inv
502: mr_get_safety_stock(V_item_id) ; /* Get Safety Stock Details */
503: -- mr_schedule_parms;
504:
505: -- Added LEXP for Lot expiry project B3219257 Rajesh Patangya 10/28/2003

Line 941: FROM ic_whse_inv

937: PROCEDURE mr_get_safety_stock(V_item_id NUMBER) IS
938:
939: CURSOR Cur_unit_safety_stock(C_item_id NUMBER) IS
940: SELECT safety_stock
941: FROM ic_whse_inv
942: WHERE item_id= C_item_id
943: AND whse_code is NULL and delete_mark=0;
944:
945: X_whse_cnt NUMBER(5);

Line 952: ' FROM ic_whse_inv'||

948: cur_sstock NUMBER;
949: BEGIN
950:
951: X_select1 :='SELECT sum(safety_stock) total_ss,count(*) no_ss'||
952: ' FROM ic_whse_inv'||
953: ' WHERE item_id= to_char(:1) ' ||
954: ' AND whse_code in ('|| G_whse_list ||') and delete_mark=0';
955:
956: IF G_whse_list IS NOT NULL THEN