APPS.GMF_VIB dependencies on MTL_SYSTEM_ITEMS_B

Line 1084: mtl_system_items_b msi,

1080: SELECT mmt.inventory_item_id, mmt.organization_id, /* mtln.lot_number, */ mmt.primary_quantity, msi.primary_uom_code,
1081: mmt.transaction_date, md.line_type, tp.transaction_id2 as reverse_id, l.ROWID, l.*
1082: FROM gmf_outgoing_material_layers l,
1083: mtl_material_transactions mmt,
1084: mtl_system_items_b msi,
1085: gme_material_details md,
1086: gme_transaction_pairs tp
1087: WHERE
1088: mmt.transaction_source_type_id = 5 AND

Line 1105: mtl_system_items_b msi,

1101: CURSOR c_ing_layers_cnt (p_ing_material_detail_id NUMBER) IS -- Bug 8472152 Added cursor
1102: SELECT count(*)
1103: FROM gmf_outgoing_material_layers l,
1104: mtl_material_transactions mmt,
1105: mtl_system_items_b msi,
1106: gme_material_details md,
1107: gme_transaction_pairs tp
1108: WHERE
1109: mmt.transaction_source_type_id = 5 AND

Line 1724: FROM gme_material_details m, mtl_system_items_b i

1720: IF req.ing_material_detail_id IS NOT NULL THEN
1721:
1722: SELECT m.dtl_um, m.line_type, i.primary_uom_code
1723: INTO l_doc_um, l_line_type, l_item_um
1724: FROM gme_material_details m, mtl_system_items_b i
1725: WHERE
1726: m.batch_id = req.batch_id AND
1727: m.material_detail_id = req.ing_material_detail_id AND
1728: i.inventory_item_id = m.inventory_item_id AND

Line 1911: mtl_system_items_b msi, gme_transaction_pairs tp

1907: NULL lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1908: l.layer_doc_qty
1909: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1910: gme_material_details md,
1911: mtl_system_items_b msi, gme_transaction_pairs tp
1912: WHERE
1913: t.trx_source_line_id = p_ing_material_detail_id AND
1914: t.transaction_source_id = p_batch_id AND
1915: t.transaction_source_type_id = 5 AND