eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_VIB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1068: mtl_transaction_lot_numbers mtln,

1064: SELECT mmt.inventory_item_id, mmt.organization_id, /* mtln.lot_number, */ mmt.primary_quantity, msi.primary_uom_code,
1065: mmt.transaction_date, md.line_type, tp.transaction_id2 as reverse_id, l.ROWID, l.*
1066: FROM gmf_outgoing_material_layers l,
1067: mtl_material_transactions mmt,
1068: mtl_transaction_lot_numbers mtln,
1069: mtl_system_items_b msi,
1070: gme_material_details md,
1071: gme_transaction_pairs tp
1072: WHERE

Line 1831: mtl_transaction_lot_numbers mtln

1827: SELECT l.*, t.primary_quantity,
1828: t.inventory_item_id -- Bug 5607069
1829: FROM gmf_incoming_material_layers l,
1830: mtl_material_transactions t,
1831: mtl_transaction_lot_numbers mtln
1832: WHERE
1833: t.trx_source_line_id = p_prod_material_detail_id AND
1834: t.transaction_source_id = p_batch_id AND
1835: t.transaction_source_type_id = 5 AND

Line 1849: mtl_transaction_lot_numbers mtln, gme_material_details md,

1845: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.inventory_item_id, t.transaction_date,
1846: mtln.lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1847: l.layer_doc_qty
1848: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1849: mtl_transaction_lot_numbers mtln, gme_material_details md,
1850: mtl_system_items_b msi, gme_transaction_pairs tp
1851: WHERE
1852: t.trx_source_line_id = p_ing_material_detail_id AND
1853: t.transaction_source_id = p_batch_id AND