APPS.WMS_OVERPICK dependencies on MTL_SYSTEM_ITEMS

Line 80: from mtl_system_items

76: WHERE transaction_temp_id = p_temp_id;
77:
78: SELECT lot_control_code, revision_qty_control_code, serial_number_control_code, primary_uom_code
79: INTO l_lot_control_code, l_revision_qty_control_code, l_serial_number_control_code, l_primary_uom
80: from mtl_system_items
81: where inventory_item_id = l_item_id AND organization_id = l_org_id;
82:
83: -- check whether item is lot controlled from mtl_system_items
84: IF ( (l_lot_control_code = NULL) OR (l_lot_control_code = 1))

Line 83: -- check whether item is lot controlled from mtl_system_items

79: INTO l_lot_control_code, l_revision_qty_control_code, l_serial_number_control_code, l_primary_uom
80: from mtl_system_items
81: where inventory_item_id = l_item_id AND organization_id = l_org_id;
82:
83: -- check whether item is lot controlled from mtl_system_items
84: IF ( (l_lot_control_code = NULL) OR (l_lot_control_code = 1))
85: THEN l_is_lot_control := FALSE;
86: ELSE l_is_lot_control := TRUE;
87: END IF;

Line 89: -- check whether item is revision controlled from mtl_system_items

85: THEN l_is_lot_control := FALSE;
86: ELSE l_is_lot_control := TRUE;
87: END IF;
88:
89: -- check whether item is revision controlled from mtl_system_items
90: IF ( (l_revision_qty_control_code = NULL) OR (l_revision_qty_control_code = 1))
91: THEN l_is_revision_control := FALSE;
92: ELSE l_is_revision_control := TRUE;
93: END IF;

Line 95: -- check whether item is serial controlled from mtl_system_items

91: THEN l_is_revision_control := FALSE;
92: ELSE l_is_revision_control := TRUE;
93: END IF;
94:
95: -- check whether item is serial controlled from mtl_system_items
96: IF ( (l_serial_number_control_code = NULL) OR (l_serial_number_control_code = 1))
97: THEN l_is_serial_control := FALSE;
98: ELSE l_is_serial_control := TRUE;
99: END IF;