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 1970: FROM mtl_serial_numbers

1966: END IF;
1967:
1968: SELECT status_id
1969: INTO l_status_id
1970: FROM mtl_serial_numbers
1971: WHERE current_organization_id = p_organization_id
1972: AND inventory_item_id = p_inventory_item_id
1973: AND serial_number = p_serial_number;
1974: EXCEPTION

Line 2980: FOR l_column_csr IN column_csr ('MTL_SERIAL_NUMBERS_INTERFACE'

2976: , l_industry
2977: , l_oracle_schema
2978: );
2979:
2980: FOR l_column_csr IN column_csr ('MTL_SERIAL_NUMBERS_INTERFACE'
2981: , l_oracle_schema
2982: )
2983: LOOP
2984: l_column_idx := l_column_idx + 1;

Line 3135: , p_table_name => 'MTL_SERIAL_NUMBERS'

3131: , x_attributes_default_count => l_attributes_default_count
3132: , x_return_status => x_return_status
3133: , x_msg_count => x_msg_count
3134: , x_msg_data => x_msg_data
3135: , p_table_name => 'MTL_SERIAL_NUMBERS'
3136: , p_attributes_name => 'Serial Attributes'
3137: , p_inventory_item_id => p_inventory_item_id
3138: , p_organization_id => p_organization_id
3139: , p_lot_serial_number => p_ser_number

Line 4066: l_st_var_index mtl_serial_numbers.serial_number%TYPE;

4062: l_temp_qty NUMBER;
4063: l_att_qty NUMBER;
4064: l_qoh_qty NUMBER;
4065: l_lpn_qty NUMBER;
4066: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4067: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4068: l_lot_serial_count NUMBER;
4069: l_serial_code NUMBER;
4070: l_is_serial_control VARCHAR2 (10);

Line 4067: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;

4063: l_att_qty NUMBER;
4064: l_qoh_qty NUMBER;
4065: l_lpn_qty NUMBER;
4066: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4067: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4068: l_lot_serial_count NUMBER;
4069: l_serial_code NUMBER;
4070: l_is_serial_control VARCHAR2 (10);
4071: l_return_values VARCHAR2 (1);

Line 4713: l_end_ser mtl_serial_numbers.serial_number%TYPE;

4709: , p_st_ser_parent_loc_tbl IN parent_loc_table
4710: )
4711: IS
4712: l_proc_msg VARCHAR2 (255);
4713: l_end_ser mtl_serial_numbers.serial_number%TYPE;
4714: l_qty NUMBER;
4715: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4716: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4717: l_debug NUMBER;

Line 4715: l_st_var_index mtl_serial_numbers.serial_number%TYPE;

4711: IS
4712: l_proc_msg VARCHAR2 (255);
4713: l_end_ser mtl_serial_numbers.serial_number%TYPE;
4714: l_qty NUMBER;
4715: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4716: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4717: l_debug NUMBER;
4718: l_validation_status VARCHAR2 (1);
4719: l_primary_uom VARCHAR2(10);

Line 4716: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;

4712: l_proc_msg VARCHAR2 (255);
4713: l_end_ser mtl_serial_numbers.serial_number%TYPE;
4714: l_qty NUMBER;
4715: l_st_var_index mtl_serial_numbers.serial_number%TYPE;
4716: l_rs_var_index mtl_serial_numbers.serial_number%TYPE;
4717: l_debug NUMBER;
4718: l_validation_status VARCHAR2 (1);
4719: l_primary_uom VARCHAR2(10);
4720:

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

5524: IS
5525: l_restrict_serial_rcpt NUMBER;
5526: rollback_serial_update EXCEPTION;
5527:
5528: TYPE osfm_ser_tbl IS TABLE OF mtl_serial_numbers.serial_number%TYPE;
5529:
5530: l_ser_number_tbl osfm_ser_tbl;
5531: l_attributes_default_count NUMBER;
5532: l_ret NUMBER;

Line 5595: FROM mtl_serial_numbers msn

5591: END IF;
5592:
5593: SELECT serial_number
5594: BULK COLLECT INTO l_ser_number_tbl
5595: FROM mtl_serial_numbers msn
5596: WHERE msn.inventory_item_id = p_item_id
5597: AND msn.wip_entity_id = p_wip_entity_id
5598: AND ( msn.intraoperation_step_type IS NULL
5599: OR msn.intraoperation_step_type <> 5

Line 5733: UPDATE mtl_serial_numbers

5729: , 'update_item_serial'
5730: );
5731: END IF;
5732:
5733: UPDATE mtl_serial_numbers
5734: SET inventory_item_id = NVL (p_to_item_id, inventory_item_id)
5735: , wip_entity_id = NVL (p_to_wip_entity_id, wip_entity_id)
5736: , operation_seq_num = p_to_operation_sequence
5737: , intraoperation_step_type = p_intraoperation_step_type

Line 5824: UPDATE mtl_serial_numbers

5820: IF (l_debug) THEN
5821: print_debug ('Update MSN when p_to_item_id <> p_item_id', 'update_item_serial');
5822: END IF;
5823:
5824: UPDATE mtl_serial_numbers
5825: SET inventory_item_id = NVL (p_to_item_id, inventory_item_id)
5826: , wip_entity_id = NVL (p_to_wip_entity_id, wip_entity_id)
5827: , operation_seq_num = p_to_operation_sequence
5828: , intraoperation_step_type = p_intraoperation_step_type

Line 5847: UPDATE mtl_serial_numbers

5843: IF (l_debug) THEN
5844: print_debug ('Update MSN when p_to_item_id = p_item_id', 'update_item_serial');
5845: END IF;
5846:
5847: UPDATE mtl_serial_numbers
5848: SET inventory_item_id = NVL (p_to_item_id, inventory_item_id)
5849: , wip_entity_id = NVL (p_to_wip_entity_id, wip_entity_id)
5850: , operation_seq_num = p_to_operation_sequence
5851: , intraoperation_step_type = p_intraoperation_step_type