APPS.INV_MWB_LOCATION_TREE dependencies on MTL_SYSTEM_ITEMS

Line 1085: FROM mtl_system_items

1081: serial_number_control_code
1082: INTO l_rev_control,
1083: l_lot_control,
1084: l_serial_control
1085: FROM mtl_system_items
1086: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1087: AND organization_id = inv_mwb_globals.g_tree_organization_id;
1088:
1089: IF inv_mwb_globals.g_tree_mat_loc_id = 1 THEN

Line 1688: FROM mtl_system_items

1684: SELECT lot_control_code
1685: , serial_number_control_code
1686: INTO l_lot_control
1687: , l_serial_control
1688: FROM mtl_system_items
1689: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1690: AND organization_id = inv_mwb_globals.g_tree_organization_id;
1691:
1692: IF inv_mwb_globals.g_tree_loc_id IS NULL THEN

Line 2134: FROM mtl_system_items

2130:
2131: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
2132: SELECT serial_number_control_code
2133: INTO serial_control
2134: FROM mtl_system_items
2135: WHERE organization_id = inv_mwb_globals.g_tree_organization_id
2136: AND inventory_item_id = inv_mwb_globals.g_tree_item_id;
2137:
2138: IF (inv_mwb_globals.g_tree_mat_loc_id = 1) THEN

Line 3379: FROM mtl_system_items

3375:
3376: IF inv_mwb_globals.g_tree_item_id IS NOT NULL THEN
3377: SELECT lot_control_code
3378: INTO l_lot_control
3379: FROM mtl_system_items
3380: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
3381: AND organization_id = inv_mwb_globals.g_tree_organization_id;
3382: END IF;
3383: