APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 527: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;

523: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
524: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
525: L_txn_header_id NUMBER;
526: L_txn_temp_id NUMBER;
527: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;
528: L_p_uom_qty NUMBER;
529: L_number_of_counts NUMBER;
530: L_success_flag NUMBER;
531: --

Line 611: mtl_system_items

607: SELECT auto_serial_alpha_prefix
608: INTO
609: L_serial_prefix
610: FROM
611: mtl_system_items
612: WHERE
613: inventory_item_id = MTL_CCEOI_VAR_PVT.G_inventory_item_id
614: AND organization_id =
615: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.organization_id;

Line 1656: -- FROM TABLE MTL_SYSTEM_ITEMS

1652: -- p_count_quantity IN NUMBER (required)
1653: -- Quantity OF the current COUNT FOR teh specific item
1654: --
1655: -- p_serial_number_control_code IN NUMBER (required)
1656: -- FROM TABLE MTL_SYSTEM_ITEMS
1657: --
1658: -- p_serial_count_option IN NUMBER (required)
1659: -- FROM TABLE MTL_CYCLE_COUNT_HEADERS
1660: --

Line 2120: from mtl_system_items

2116: CURSOR L_ItemErrMeas_Csr (itemid in number, org in number) is
2117: select
2118: positive_measurement_error
2119: , negative_measurement_error
2120: from mtl_system_items
2121: where inventory_item_id = itemid
2122: and organization_id = org;
2123: --
2124: L_positive_measurement_error number;

Line 4031: L_table_name := 'MTL_SYSTEM_ITEMS';

4027: END IF;
4028: IF x_errorcode >0 THEN
4029: IF x_errorcode = 4 THEN
4030: L_message_name := 'INV_CCEOI_NO_ITEM';
4031: L_table_name := 'MTL_SYSTEM_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';

Line 4168: L_table_name := 'MTL_SYSTEM_ITEMS';

4164: mdebug('Process: In Validate_ItemSKU call Val_Ctrol Return='||x_return_status);
4165: END IF;
4166: --
4167: IF x_errorcode >0 THEN
4168: L_table_name := 'MTL_SYSTEM_ITEMS';
4169: IF x_errorcode = 9 THEN
4170: L_message_name := 'INV_CCEOI_NO_LOC';
4171: L_column_name := 'LOCATION_CONTROL_CODE';
4172: ELSIF x_errorcode = 11 THEN

Line 6470: , p_error_table_name => 'MTL_SYSTEM_ITEMS'

6466: -- Write INTO interface error TABLE
6467: mtl_cceoi_process_pvt.insert_cceoierror
6468: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6469: , p_error_column_name => 'SECONDARY_UOM_CODE'
6470: , p_error_table_name => 'MTL_SYSTEM_ITEMS'
6471: , p_message_name => 'INV_INCORRECT_SECONDARY_UOM');
6472: RAISE fnd_api.g_exc_error;
6473: END IF;
6474: