APPS.GMF_VIB dependencies on MTL_SYSTEM_ITEMS_B

Line 1069: mtl_system_items_b msi,

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
1073: mmt.transaction_source_type_id = 5 AND

Line 1664: FROM gme_material_details m, mtl_system_items_b i

1660: IF req.ing_material_detail_id IS NOT NULL THEN
1661:
1662: SELECT m.dtl_um, m.line_type, i.primary_uom_code
1663: INTO l_doc_um, l_line_type, l_item_um
1664: FROM gme_material_details m, mtl_system_items_b i
1665: WHERE
1666: m.batch_id = req.batch_id AND
1667: m.material_detail_id = req.ing_material_detail_id AND
1668: i.inventory_item_id = m.inventory_item_id AND

Line 1850: mtl_system_items_b msi, gme_transaction_pairs tp

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
1854: t.transaction_source_type_id = 5 AND