DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_CYCLE_COUNT_ITEMS

Line 4178: L_table_name := 'MTL_CYCLE_COUNT_ITEMS';

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

Line 5773: FROM MTL_CYCLE_COUNT_ITEMS i

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