APPS.GMD_QMSMC dependencies on MTL_LOT_NUMBERS

Line 172: FROM MTL_LOT_NUMBERS C,

168: -- Bug 4440045: added the inv_lot cursor
169: CURSOR inv_lot IS
170: SELECT c.PARENT_LOT_NUMBER,
171: c.LOT_NUMBER
172: FROM MTL_LOT_NUMBERS C,
173: MTL_MATERIAL_TRANSACTIONS M,
174: MTL_TRANSACTION_LOT_NUMBERS L
175: WHERE M.transaction_id = l_event_key
176: AND M.inventory_item_id = C.inventory_item_id

Line 200: FROM mtl_lot_numbers A,

196: B.primary_uom_code,
197: B.primary_uom_code,
198: A.expiration_date,
199: A.Retest_Date
200: FROM mtl_lot_numbers A,
201: mtl_system_items_b_kfv B,
202: mtl_parameters mp --RLNAGARA B4905645
203: WHERE
204: A.inventory_item_id = B.inventory_item_id AND

Line 262: FROM mtl_lot_numbers

258:
259: --RLNAGARA Bug5334308 Added cursor get_lot and modified cursor recv_inv
260: CURSOR get_lot(p_gen_obj_id NUMBER) IS
261: SELECT LOT_NUMBER
262: FROM mtl_lot_numbers
263: WHERE GEN_OBJECT_ID = p_gen_obj_id;
264:
265: CURSOR recv_inv(p_trans_id NUMBER,p_lot_number VARCHAR2) IS
266: SELECT so.organization_code,

Line 300: mtl_lot_numbers lot,

296: rcv_shipment_lines sl,
297: po_headers_all po ,
298: rcv_shipment_headers sh ,
299: rcv_lot_transactions tran ,
300: mtl_lot_numbers lot,
301: hr_operating_units hou
302: WHERE rt.TRANSACTION_ID = p_trans_id
303: AND rt.shipment_header_id = sl.shipment_header_id
304: AND rt.shipment_line_id = sl.shipment_line_id