APPS.WMS_ASN_LOT_ATT dependencies on MTL_SERIAL_NUMBERS

Line 1442: from mtl_serial_numbers_interface

1438: , ATTRIBUTE12
1439: , ATTRIBUTE13
1440: , ATTRIBUTE14
1441: , ATTRIBUTE15
1442: from mtl_serial_numbers_interface
1443: where TRANSACTION_INTERFACE_ID = P_SERIAL_TRANSACTION_INTF_ID;
1444:
1445: l_input_idx BINARY_INTEGER;
1446:

Line 1582: p_table_name => 'MTL_SERIAL_NUMBERS',

1578: x_attributes_default_count => l_attributes_default_count,
1579: x_return_status => l_return_status,
1580: x_msg_count => l_msg_count,
1581: x_msg_data => l_msg_data,
1582: p_table_name => 'MTL_SERIAL_NUMBERS',
1583: p_attributes_name => 'Serial Attributes',
1584: p_inventory_item_id => p_inventory_item_id,
1585: p_organization_id => p_organization_id,
1586: p_lot_serial_number => p_serial_number,

Line 1834: INSERT INTO MTL_SERIAL_NUMBERS(

1830: print_debug('Before Inserting into MTL_SERIAL_NUMBER' , 4);
1831: END IF;
1832:
1833:
1834: INSERT INTO MTL_SERIAL_NUMBERS(
1835: INVENTORY_ITEM_ID,
1836: SERIAL_NUMBER,
1837: LAST_UPDATE_DATE,
1838: LAST_UPDATED_BY,

Line 2199: -- total number of serials inserted into mtl_serial_numbers

2195: IF (l_debug = 1) THEN
2196: print_debug('At Step = '|| l_progress,4);
2197: END IF;
2198:
2199: -- total number of serials inserted into mtl_serial_numbers
2200: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
2201:
2202: l_progress := '40';
2203: IF (l_debug = 1) THEN

Line 2227: FROM mtl_serial_numbers

2223: -- check the status code and group_mark_id
2224: BEGIN
2225: SELECT current_status, group_mark_id
2226: INTO l_current_status, l_group_mark_id
2227: FROM mtl_serial_numbers
2228: WHERE serial_number = l_cur_serial_number
2229: AND inventory_item_id = p_inventory_item_id;
2230:
2231: EXCEPTION