APPS.GMICOMN dependencies on IC_ITEM_MST

Line 43: | IC_ITEM_MST table. |

39: | Used to retrieve the Item number for the Item id. |
40: | |
41: | DESCRIPTION |
42: | This procedure is used to retrieve the item number from the |
43: | IC_ITEM_MST table. |
44: | |
45: | PARAMETERS |
46: | V_Item_id IN NUMBER - Item ID |
47: | |

Line 59: FROM ic_item_mst

55: x_item_no VARCHAR2 (32);
56: BEGIN
57: SELECT item_no
58: INTO x_item_no
59: FROM ic_item_mst
60: WHERE item_id = v_item_id;
61: RETURN (x_item_no);
62: END get_itemno;
63: