DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_CYCLE_COUNT_ITEMS

Line 4036: L_table_name := 'MTL_CYCLE_COUNT_ITEMS';

4032: L_column_name := 'INVENTORY_ITEM AND ITEM_SEGMENTS';
4033: ELSIF
4034: x_errorcode = 5 THEN
4035: L_message_name := 'INV_CCEOI_INVALID_ITEM';
4036: L_table_name := 'MTL_CYCLE_COUNT_ITEMS';
4037: L_column_name := 'INVENTORY_ITEM_ID';
4038: END IF;
4039:
4040: -- Write INTO interface error TABLE

Line 5598: FROM MTL_CYCLE_COUNT_ITEMS i

5594: ,c.APPROVAL_TOLERANCE_POSITIVE CLASS_TOL_POS
5595: ,c.APPROVAL_TOLERANCE_NEGATIVE CLASS_TOL_NEG
5596: ,c.COST_TOLERANCE_POSITIVE CLASS_COST_POS
5597: ,c.COST_TOLERANCE_NEGATIVE CLASS_COST_NEG
5598: FROM MTL_CYCLE_COUNT_ITEMS i
5599: , MTL_CYCLE_COUNT_CLASSES c
5600: WHERE i.cycle_count_Header_id = cheader
5601: AND i.inventory_item_id = item
5602: AND c.abc_class_id = i.abc_class_id