APPS.GMPMRRP dependencies on IC_ITEM_MST

Line 255: ||' FROM ps_oper_pcl c, ps_plng_cls p, ic_item_mst i, '

251: cur_planning NUMBER;
252: BEGIN
253: -- Building of the Where clause.
254: X_where := 'SELECT i.planning_class,i.item_id '
255: ||' FROM ps_oper_pcl c, ps_plng_cls p, ic_item_mst i, '
256: ||' fnd_user f '
257: ||' WHERE c.delete_mark=0 ' ;
258:
259: X_where := X_where

Line 455: FROM ic_item_mst

451:
452: --Bug 3168907 Kalyani Manda Added the cursor.
453: Cursor Cur_get_whse_item_id ( V_item_id NUMBER) IS
454: SELECT whse_item_id
455: FROM ic_item_mst
456: WHERE item_id = V_item_id;
457:
458: X_sel_whse_list VARCHAR2(2000) := '';
459: X_matl_whse VARCHAR2(4);