4174: L_column_name := 'INVENTORY_ITEM AND ITEM_SEGMENTS';
4175: ELSIF
4176: x_errorcode = 5 THEN
4177: L_message_name := 'INV_CCEOI_INVALID_ITEM';
4178: L_table_name := 'MTL_CYCLE_COUNT_ITEMS';
4179: L_column_name := 'INVENTORY_ITEM_ID';
4180: END IF;
4181:
4182: -- Write INTO interface error TABLE
5769: ,c.APPROVAL_TOLERANCE_POSITIVE CLASS_TOL_POS
5770: ,c.APPROVAL_TOLERANCE_NEGATIVE CLASS_TOL_NEG
5771: ,c.COST_TOLERANCE_POSITIVE CLASS_COST_POS
5772: ,c.COST_TOLERANCE_NEGATIVE CLASS_COST_NEG
5773: FROM MTL_CYCLE_COUNT_ITEMS i
5774: , MTL_CYCLE_COUNT_CLASSES c
5775: WHERE i.cycle_count_Header_id = cheader
5776: AND i.inventory_item_id = item
5777: AND c.abc_class_id = i.abc_class_id