APPS.GMICOMN dependencies on IC_LOTS_MST

Line 73: | IC_LOTS_MST table. |

69: | Used to retrieve the Lot number for the Item id and Lot Id |
70: | |
71: | DESCRIPTION |
72: | This procedure is used to retrieve the Lot number from the |
73: | IC_LOTS_MST table. |
74: | |
75: | PARAMETERS |
76: | V_Lot_id IN NUMBER - Lot ID | |
77: | V_Item_id IN NUMBER - Item ID |

Line 91: FROM ic_lots_mst

87: x_lot_no VARCHAR2 (32);
88: BEGIN
89: SELECT Lot_no
90: INTO x_lot_no
91: FROM ic_lots_mst
92: WHERE Item_id = v_Item_Id
93: AND Lot_id = v_lot_id;
94: RETURN (x_lot_no);
95: END get_Lotno;