APPS.GMI_MSCA_PUB dependencies on IC_LOTS_MST

Line 164: FROM ic_lots_mst A, ic_loct_inv B

160:
161:
162: /* OPM Note : LOT statement in form ICQTYED:
163: SELECT DISTINCT A.lot_no, A.sublot_no
164: FROM ic_lots_mst A, ic_loct_inv B
165: WHERE A.lot_id = B.lot_id AND A.delete_mark = 0 AND B.delete_mark = 0
166: AND B.item_id = :PARAMETER.item_id and a.item_id = b.item_id
167: AND lot_no <> :parameter.default_lot
168: UNION

Line 170: from ic_lots_mst

166: AND B.item_id = :PARAMETER.item_id and a.item_id = b.item_id
167: AND lot_no <> :parameter.default_lot
168: UNION
169: select lot_no, sublot_no
170: from ic_lots_mst
171: where item_id = :parameter.item_id
172: and (substr(:ic_jrnl_mst.trans_type,1,3) in ('CRE','ADJ')) and delete_mark = 0
173: and lot_no <> :parameter.default_lot
174: ORDER BY 1, 2

Line 181: FROM ic_lots_mst A, ic_loct_inv B

177:
178: OPEN x_lot_cursor FOR
179: SELECT DISTINCT A.lot_no, NVL(A.sublot_no, ' '), NVL(A.lot_desc, ' ')
180: , A.lot_id, A.item_id, NVL(A.qc_grade, ' '), B.lot_status
181: FROM ic_lots_mst A, ic_loct_inv B
182: WHERE A.lot_id = B.lot_id
183: AND A.lot_no LIKE p_lot
184: AND A.delete_mark = 0
185: AND B.delete_mark = 0

Line 193: FROM ic_lots_mst A

189: AND NVL(p_location, B.location) = B.location
190: UNION
191: SELECT DISTINCT A.lot_no, NVL(A.sublot_no, ' '), NVL(A.lot_desc, ' ')
192: , A.lot_id, A.item_id, NVL(A.qc_grade, ' '), null
193: FROM ic_lots_mst A
194: WHERE A.lot_no LIKE p_lot
195: AND A.delete_mark = 0
196: AND A.item_id IN (SELECT item_id FROM ic_item_mst WHERE item_no = p_item_no)
197: AND A.lot_id > 0

Line 280: FROM ic_lots_mst A

276: print_debug('in sublot item='||p_item_no||', lot='||p_lot||', sublot='||p_sublot||'.');
277: OPEN x_sublot_cursor FOR
278: SELECT DISTINCT A.lot_no, NVL(A.sublot_no, ' '), NVL(A.lot_desc, ' ')
279: , A.lot_id, A.item_id, NVL(A.qc_grade, ' '), B.lot_status
280: FROM ic_lots_mst A
281: , ic_loct_inv B
282: WHERE B.lot_id = A.lot_id
283: AND B.item_id = A.item_id
284: AND A.sublot_no like p_sublot