DBA Data[Home] [Help]

APPS.GMPMRACT dependencies on IC_ITEM_MST

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

292: cur_planning NUMBER;
293: BEGIN
294: -- Building of the Where clause.
295: X_where := 'SELECT i.planning_class,i.item_id '
296: ||' FROM ps_oper_pcl c, ps_plng_cls p, ic_item_mst i, '
297: ||' fnd_user f '
298: ||' WHERE c.delete_mark=0 ' ;
299:
300: X_where := X_where

Line 755: FROM ic_item_mst

751:
752: --Bug 3168907 Kalyani Manda Added the cursor.
753: Cursor Cur_get_whse_item_id ( V_item_id NUMBER) IS
754: SELECT whse_item_id
755: FROM ic_item_mst
756: WHERE item_id = V_item_id;
757:
758:
759: X_sel_whse_list VARCHAR2(2000);