APPS.PO_GML_DB_COMMON dependencies on IC_LOTS_MST

Line 176: l_lot_id ic_lots_mst.lot_id%TYPE;

172: v_progress VARCHAR2(3) := '010';
173: l_whse_code ic_whse_mst.whse_code%TYPE;
174: l_location ic_loct_mst.location%TYPE;
175: l_quantity_onhand NUMBER;
176: l_lot_id ic_lots_mst.lot_id%TYPE;
177: BEGIN
178: BEGIN
179: --get lot id
180: IF (psublot_no is NULL) THEN

Line 182: from ic_lots_mst

178: BEGIN
179: --get lot id
180: IF (psublot_no is NULL) THEN
181: select lot_id INTO l_lot_id
182: from ic_lots_mst
183: where item_id = pitem_id
184: and lot_no = plot_no
185: and sublot_no is null;
186:

Line 190: from ic_lots_mst

186:
187: ELSE
188:
189: select lot_id INTO l_lot_id
190: from ic_lots_mst
191: where item_id = pitem_id
192: and lot_no = plot_no
193: and sublot_no = psublot_no;
194:

Line 422: l_lot_no ic_lots_mst.lot_no%TYPE;

418: l_location ic_tran_pnd.location%TYPE;
419: l_user_id ic_tran_pnd.created_by%TYPE;
420: l_doc_type ic_tran_pnd.doc_type%TYPE;
421: l_non_inv ic_item_mst.noninv_ind%TYPE;
422: l_lot_no ic_lots_mst.lot_no%TYPE;
423: l_sublot_no ic_lots_mst.sublot_no%TYPE;
424: ex_exception_found EXCEPTION;
425:
426: l_creation_date DATE;

Line 423: l_sublot_no ic_lots_mst.sublot_no%TYPE;

419: l_user_id ic_tran_pnd.created_by%TYPE;
420: l_doc_type ic_tran_pnd.doc_type%TYPE;
421: l_non_inv ic_item_mst.noninv_ind%TYPE;
422: l_lot_no ic_lots_mst.lot_no%TYPE;
423: l_sublot_no ic_lots_mst.sublot_no%TYPE;
424: ex_exception_found EXCEPTION;
425:
426: l_creation_date DATE;
427:

Line 965: from ic_lots_mst

961: IF l_tran_rec.lot_id > 0 THEN
962:
963: select qc_grade
964: into l_tran_rec.qc_grade
965: from ic_lots_mst
966: where item_id = l_tran_rec.item_id
967: and lot_id = l_tran_rec.lot_id;
968:
969: /* Select lot status Check a record in ic_loct_inv for the item,lot,warehouse,location

Line 1138: from ic_lots_mst

1134: BEGIN
1135: IF l_lot_attributes_rec.sublot_num is not null then
1136: Select lot_id, qc_grade
1137: into l_tran_rec.lot_id, l_tran_rec.qc_grade
1138: from ic_lots_mst
1139: where lot_no = l_lot_attributes_rec.lot_num
1140: and sublot_no = l_lot_attributes_rec.sublot_num
1141: and item_id = l_item_id;
1142: ELSE

Line 1145: from ic_lots_mst

1141: and item_id = l_item_id;
1142: ELSE
1143: Select lot_id, qc_grade
1144: into l_tran_rec.lot_id, l_tran_rec.qc_grade
1145: from ic_lots_mst
1146: where lot_no = l_lot_attributes_rec.lot_num
1147: and sublot_no is null
1148: and item_id = l_item_id;
1149: End if;