APPS.INV_MWB_ITEM_TREE dependencies on MTL_SYSTEM_ITEMS

Line 148: FROM mtl_system_items

144: serial_number_control_code
145: INTO l_rev_control,
146: l_lot_control,
147: l_serial_control
148: FROM mtl_system_items
149: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
150: AND organization_id = inv_mwb_globals.g_tree_organization_id;
151:
152: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 269: FROM mtl_system_items

265: SELECT lot_control_code,
266: serial_number_control_code
267: INTO l_lot_control,
268: l_serial_control
269: FROM mtl_system_items
270: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
271: AND organization_id = inv_mwb_globals.g_tree_organization_id;
272:
273: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 376: FROM mtl_system_items

372: SELECT revision_qty_control_code,
373: serial_number_control_code
374: INTO l_rev_control,
375: l_serial_control
376: FROM mtl_system_items
377: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
378: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
379:
380: IF inv_mwb_globals.g_chk_onhand = 1 THEN

Line 477: FROM mtl_system_items

473: SELECT revision_qty_control_code,
474: lot_control_code
475: INTO l_rev_control,
476: l_lot_control
477: FROM mtl_system_items
478: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
479: AND organization_id = inv_mwb_globals.g_tree_organization_id;
480:
481: IF inv_mwb_globals.g_chk_onhand = 1 THEN