eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on MTL_SERIAL_NUMBERS

Line 1908: FROM mtl_serial_numbers

1904: END IF;
1905:
1906: SELECT status_id
1907: INTO l_status_id
1908: FROM mtl_serial_numbers
1909: WHERE current_organization_id = p_organization_id
1910: AND inventory_item_id = p_inventory_item_id
1911: AND serial_number = p_serial_number;
1912: EXCEPTION

Line 2939: FOR l_column_csr IN column_csr ('MTL_SERIAL_NUMBERS_INTERFACE'

2935: , l_industry
2936: , l_oracle_schema
2937: );
2938:
2939: FOR l_column_csr IN column_csr ('MTL_SERIAL_NUMBERS_INTERFACE'
2940: , l_oracle_schema
2941: )
2942: LOOP
2943: l_column_idx := l_column_idx + 1;

Line 3094: , p_table_name => 'MTL_SERIAL_NUMBERS'

3090: , x_attributes_default_count => l_attributes_default_count
3091: , x_return_status => x_return_status
3092: , x_msg_count => x_msg_count
3093: , x_msg_data => x_msg_data
3094: , p_table_name => 'MTL_SERIAL_NUMBERS'
3095: , p_attributes_name => 'Serial Attributes'
3096: , p_inventory_item_id => p_inventory_item_id
3097: , p_organization_id => p_organization_id
3098: , p_lot_serial_number => p_ser_number

Line 4025: l_st_var_index mtl_serial_numbers.serial_number%TYPE;

4021: l_temp_qty NUMBER;
4022: l_att_qty NUMBER;
4023: l_qoh_qty NUMBER;
4024: l_lpn_qty NUMBER;
4025: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4026: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4027: l_lot_serial_count NUMBER;
4028: l_serial_code NUMBER;
4029: l_is_serial_control VARCHAR2 (10);

Line 4026: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;

4022: l_att_qty NUMBER;
4023: l_qoh_qty NUMBER;
4024: l_lpn_qty NUMBER;
4025: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4026: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4027: l_lot_serial_count NUMBER;
4028: l_serial_code NUMBER;
4029: l_is_serial_control VARCHAR2 (10);
4030: l_return_values VARCHAR2 (1);

Line 4684: l_end_ser mtl_serial_numbers.serial_number%TYPE;

4680: , p_st_ser_parent_loc_tbl IN parent_loc_table
4681: )
4682: IS
4683: l_proc_msg VARCHAR2 (255);
4684: l_end_ser mtl_serial_numbers.serial_number%TYPE;
4685: l_qty NUMBER;
4686: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4687: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4688: l_debug NUMBER;

Line 4686: l_st_var_index mtl_serial_numbers.serial_number%TYPE;

4682: IS
4683: l_proc_msg VARCHAR2 (255);
4684: l_end_ser mtl_serial_numbers.serial_number%TYPE;
4685: l_qty NUMBER;
4686: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4687: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4688: l_debug NUMBER;
4689: l_validation_status VARCHAR2 (1);
4690: l_primary_uom VARCHAR2(10);

Line 4687: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;

4683: l_proc_msg VARCHAR2 (255);
4684: l_end_ser mtl_serial_numbers.serial_number%TYPE;
4685: l_qty NUMBER;
4686: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4687: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4688: l_debug NUMBER;
4689: l_validation_status VARCHAR2 (1);
4690: l_primary_uom VARCHAR2(10);
4691:

Line 5499: TYPE osfm_ser_tbl IS TABLE OF mtl_serial_numbers.serial_number%TYPE;

5495: IS
5496: l_restrict_serial_rcpt NUMBER;
5497: rollback_serial_update EXCEPTION;
5498:
5499: TYPE osfm_ser_tbl IS TABLE OF mtl_serial_numbers.serial_number%TYPE;
5500:
5501: l_ser_number_tbl osfm_ser_tbl;
5502: l_attributes_default_count NUMBER;
5503: l_ret NUMBER;

Line 5566: FROM mtl_serial_numbers msn

5562: END IF;
5563:
5564: SELECT serial_number
5565: BULK COLLECT INTO l_ser_number_tbl
5566: FROM mtl_serial_numbers msn
5567: WHERE msn.inventory_item_id = p_item_id
5568: AND msn.wip_entity_id = p_wip_entity_id
5569: AND ( msn.intraoperation_step_type IS NULL
5570: OR msn.intraoperation_step_type <> 5

Line 5704: UPDATE mtl_serial_numbers

5700: , 'update_item_serial'
5701: );
5702: END IF;
5703:
5704: UPDATE mtl_serial_numbers
5705: SET inventory_item_id = NVL (p_to_item_id, inventory_item_id)
5706: , wip_entity_id = NVL (p_to_wip_entity_id, wip_entity_id)
5707: , operation_seq_num = p_to_operation_sequence
5708: , intraoperation_step_type = p_intraoperation_step_type

Line 5795: UPDATE mtl_serial_numbers

5791: IF (l_debug) THEN
5792: print_debug ('Update MSN when p_to_item_id <> p_item_id', 'update_item_serial');
5793: END IF;
5794:
5795: UPDATE mtl_serial_numbers
5796: SET inventory_item_id = NVL (p_to_item_id, inventory_item_id)
5797: , wip_entity_id = NVL (p_to_wip_entity_id, wip_entity_id)
5798: , operation_seq_num = p_to_operation_sequence
5799: , intraoperation_step_type = p_intraoperation_step_type

Line 5818: UPDATE mtl_serial_numbers

5814: IF (l_debug) THEN
5815: print_debug ('Update MSN when p_to_item_id = p_item_id', 'update_item_serial');
5816: END IF;
5817:
5818: UPDATE mtl_serial_numbers
5819: SET inventory_item_id = NVL (p_to_item_id, inventory_item_id)
5820: , wip_entity_id = NVL (p_to_wip_entity_id, wip_entity_id)
5821: , operation_seq_num = p_to_operation_sequence
5822: , intraoperation_step_type = p_intraoperation_step_type