APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 586: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;

582: L_from_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
583: L_txn_uom MTL_CYCLE_COUNT_ENTRIES.COUNT_UOM_CURRENT%type;
584: L_txn_header_id NUMBER;
585: L_txn_temp_id NUMBER;
586: L_serial_prefix MTL_SYSTEM_ITEMS.auto_serial_alpha_prefix%type;
587: L_p_uom_qty NUMBER;
588: L_number_of_counts NUMBER;
589: L_success_flag NUMBER;
590: L_org_id MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID%type;

Line 686: mtl_system_items

682: SELECT auto_serial_alpha_prefix
683: INTO
684: L_serial_prefix
685: FROM
686: mtl_system_items
687: WHERE
688: inventory_item_id = MTL_CCEOI_VAR_PVT.G_inventory_item_id
689: AND organization_id =
690: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.organization_id;

Line 1753: -- FROM TABLE MTL_SYSTEM_ITEMS

1749: -- p_count_quantity IN NUMBER (required)
1750: -- Quantity OF the current COUNT FOR teh specific item
1751: --
1752: -- p_serial_number_control_code IN NUMBER (required)
1753: -- FROM TABLE MTL_SYSTEM_ITEMS
1754: --
1755: -- p_serial_count_option IN NUMBER (required)
1756: -- FROM TABLE MTL_CYCLE_COUNT_HEADERS
1757: --

Line 2238: from mtl_system_items

2234: CURSOR L_ItemErrMeas_Csr (itemid in number, org in number) is
2235: select
2236: positive_measurement_error
2237: , negative_measurement_error
2238: from mtl_system_items
2239: where inventory_item_id = itemid
2240: and organization_id = org;
2241: --
2242: L_positive_measurement_error number;

Line 4173: L_table_name := 'MTL_SYSTEM_ITEMS';

4169: END IF;
4170: IF x_errorcode >0 THEN
4171: IF x_errorcode = 4 THEN
4172: L_message_name := 'INV_CCEOI_NO_ITEM';
4173: L_table_name := 'MTL_SYSTEM_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';

Line 4310: L_table_name := 'MTL_SYSTEM_ITEMS';

4306: mdebug('Process: In Validate_ItemSKU call Val_Ctrol Return='||x_return_status);
4307: END IF;
4308: --
4309: IF x_errorcode >0 THEN
4310: L_table_name := 'MTL_SYSTEM_ITEMS';
4311: IF x_errorcode = 9 THEN
4312: L_message_name := 'INV_CCEOI_NO_LOC';
4313: L_column_name := 'LOCATION_CONTROL_CODE';
4314: ELSIF x_errorcode = 11 THEN

Line 6645: , p_error_table_name => 'MTL_SYSTEM_ITEMS'

6641: -- Write INTO interface error TABLE
6642: mtl_cceoi_process_pvt.insert_cceoierror
6643: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6644: , p_error_column_name => 'SECONDARY_UOM_CODE'
6645: , p_error_table_name => 'MTL_SYSTEM_ITEMS'
6646: , p_message_name => 'INV_INCORRECT_SECONDARY_UOM');
6647: RAISE fnd_api.g_exc_error;
6648: END IF;
6649: