APPS.GMF_LAYERS dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 114: mtl_transaction_lot_numbers mtln

110: BEGIN
111: SELECT -l.layer_doc_qty, l.layer_doc_um
112: INTO l_doc_qty, l_doc_um
113: FROM gmf_incoming_material_layers l, mtl_material_transactions mmt,
114: mtl_transaction_lot_numbers mtln
115: WHERE
116: mmt.transaction_id = p_tran_rec.reverse_id AND
117: mtln.transaction_id (+) = p_tran_rec.reverse_id AND
118: mtln.lot_number (+) = p_tran_rec.lot_number AND

Line 291: mtl_transaction_lot_numbers mtln

287: FROM gmf_batch_vib_details v,
288: gmf_batch_requirements r,
289: gmf_incoming_material_layers l,
290: mtl_material_transactions mmt,
291: mtl_transaction_lot_numbers mtln
292: WHERE
293: r.batch_id = p_tran_rec.transaction_source_id AND
294: r.ing_material_detail_id = p_tran_rec.trx_source_line_id AND
295: r.delete_mark = 0 AND

Line 370: mtl_transaction_lot_numbers mtln

366: BEGIN
367: SELECT -l.layer_doc_qty, l.layer_doc_um
368: INTO l_doc_qty, l_doc_um
369: FROM gmf_outgoing_material_layers l, mtl_material_transactions mmt,
370: mtl_transaction_lot_numbers mtln
371: WHERE
372: mmt.transaction_id = p_tran_rec.reverse_id AND
373: mtln.transaction_id (+) = p_tran_rec.reverse_id AND
374: mtln.lot_number (+) = p_tran_rec.lot_number AND