APPS.INV_MWB_ITEM_TREE dependencies on MTL_SYSTEM_ITEMS

Line 152: FROM mtl_system_items

148: serial_number_control_code
149: INTO l_rev_control,
150: l_lot_control,
151: l_serial_control
152: FROM mtl_system_items
153: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
154: AND organization_id = inv_mwb_globals.g_tree_organization_id;
155:
156: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 275: FROM mtl_system_items

271: SELECT lot_control_code,
272: serial_number_control_code
273: INTO l_lot_control,
274: l_serial_control
275: FROM mtl_system_items
276: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
277: AND organization_id = inv_mwb_globals.g_tree_organization_id;
278:
279: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 384: FROM mtl_system_items

380: SELECT revision_qty_control_code,
381: serial_number_control_code
382: INTO l_rev_control,
383: l_serial_control
384: FROM mtl_system_items
385: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
386: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
387:
388: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 487: FROM mtl_system_items

483: SELECT revision_qty_control_code,
484: lot_control_code
485: INTO l_rev_control,
486: l_lot_control
487: FROM mtl_system_items
488: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
489: AND organization_id = inv_mwb_globals.g_tree_organization_id;
490:
491: IF inv_mwb_globals.g_chk_onhand = 1 THEN