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_SERIAL_NUMBER_PUB dependencies on MTL_SERIAL_NUMBERS

Line 252: INSERT INTO mtl_serial_numbers

248: l_loginid := fnd_global.login_id;
249: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, p_serial_number, x_msg_data);
250:
251: IF (isunique = 0) THEN
252: INSERT INTO mtl_serial_numbers
253: (
254: inventory_item_id
255: , serial_number
256: , last_update_date

Line 439: FROM mtl_serial_numbers_temp

435: , TO_CHAR(n_attribute9)
436: , TO_CHAR(n_attribute10)
437: , status_id
438: , territory_code
439: FROM mtl_serial_numbers_temp
440: WHERE transaction_temp_id = p_transaction_temp_id
441: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
442:
443: l_input_idx BINARY_INTEGER;

Line 593: , p_table_name => 'MTL_SERIAL_NUMBERS'

589: , x_attributes_default_count => l_attributes_default_count
590: , x_return_status => l_return_status
591: , x_msg_count => l_msg_count
592: , x_msg_data => l_msg_data
593: , p_table_name => 'MTL_SERIAL_NUMBERS'
594: , p_attributes_name => 'Serial Attributes'
595: , p_inventory_item_id => p_inventory_item_id
596: , p_organization_id => p_organization_id
597: , p_lot_serial_number => p_serial_number

Line 626: INSERT INTO mtl_serial_numbers

622: IF (p_transaction_action_id = 3
623: AND g_firstscan = FALSE) THEN
624: -- invtrace(' inserting into MSN values ');
625: ---------#-#-#-#get the values later
626: INSERT INTO mtl_serial_numbers
627: (
628: inventory_item_id
629: , serial_number
630: , last_update_date

Line 845: FROM mtl_serial_numbers

841: , NVL(p_planning_tp_type, 2)
842: , wip_entity_id
843: , operation_seq_num
844: , intraoperation_step_type
845: FROM mtl_serial_numbers
846: WHERE serial_number = p_serial_number
847: AND current_organization_id = g_transfer_org_id
848: AND inventory_item_id = p_inventory_item_id
849: AND NOT EXISTS(

Line 851: FROM mtl_serial_numbers sn

847: AND current_organization_id = g_transfer_org_id
848: AND inventory_item_id = p_inventory_item_id
849: AND NOT EXISTS(
850: SELECT NULL
851: FROM mtl_serial_numbers sn
852: WHERE sn.serial_number = p_serial_number
853: AND sn.current_organization_id = p_organization_id
854: AND sn.inventory_item_id = p_inventory_item_id);
855:

Line 860: FROM mtl_serial_numbers

856: -- prepare to insert the initial status to the status history table
857: -- bug 1870120
858: SELECT status_id
859: INTO l_status_id
860: FROM mtl_serial_numbers
861: WHERE serial_number = p_serial_number
862: AND current_organization_id = p_organization_id
863: AND inventory_item_id = p_inventory_item_id;
864: -- invtrace('l_status_id from MSN when serial_number = ' || p_serial_number || ' current_organization_id = ' || p_organization_id || 'inventory_item_id = ' || p_inventory_item_id);

Line 906: INSERT INTO mtl_serial_numbers

902: l_status_id := p_status_id;
903: END IF;
904:
905: -- invtrace('inserting into MSN values');
906: INSERT INTO mtl_serial_numbers
907: (
908: inventory_item_id
909: , serial_number
910: , last_update_date

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

1336: -- get the number part of the from serial
1337: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);
1338: -- get the number part of the to serial
1339: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
1340: -- total number of serials inserted into mtl_serial_numbers
1341: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1342:
1343: FOR i IN 1 .. l_range_numbers LOOP
1344: l_cur_ser_number := l_from_ser_number + i - 1;

Line 1361: FROM mtl_serial_numbers

1357: SELECT current_status
1358: , NVL(group_mark_id, -1)
1359: INTO l_current_status
1360: , l_group_mark_id
1361: FROM mtl_serial_numbers
1362: WHERE serial_number = l_cur_serial_number
1363: AND inventory_item_id = p_inventory_item_id;
1364: EXCEPTION
1365: WHEN NO_DATA_FOUND THEN

Line 1386: -- in mtl_serial_numbers while updating the current_status from 4 to 1.

1382: OR(l_current_status = 6
1383: AND l_group_mark_id = -1) THEN
1384:
1385: -- Bug 5385315, Update the current_organization_id to p_organization_id
1386: -- in mtl_serial_numbers while updating the current_status from 4 to 1.
1387:
1388: IF (p_current_status = 1 AND l_current_status = 4) THEN
1389: -- pre-defined serial, update status
1390: UPDATE mtl_serial_numbers

Line 1390: UPDATE mtl_serial_numbers

1386: -- in mtl_serial_numbers while updating the current_status from 4 to 1.
1387:
1388: IF (p_current_status = 1 AND l_current_status = 4) THEN
1389: -- pre-defined serial, update status
1390: UPDATE mtl_serial_numbers
1391: SET current_status = p_current_status
1392: , inspection_status = p_inspection_status
1393: , lpn_id = null --bug 5152103
1394: , current_organization_id = p_organization_id

Line 1399: UPDATE mtl_serial_numbers

1395: WHERE serial_number = l_cur_serial_number
1396: AND inventory_item_id = p_inventory_item_id;
1397: ELSE
1398: -- pre-defined serial, update status
1399: UPDATE mtl_serial_numbers
1400: SET current_status = p_current_status
1401: , inspection_status = p_inspection_status
1402: -- , lpn_id = decode(p_current_status,1,decode(current_status,4,null,lpn_id),lpn_id) --bug 5152103
1403: WHERE serial_number = l_cur_serial_number

Line 1487: UPDATE mtl_serial_numbers

1483: * If WMS or PO J are not installed or this API is called from other
1484: * routines, then updates to the serial number are retained
1485: */
1486: IF (NVL(p_rcv_serial_flag, 'N') <> 'Y') THEN
1487: UPDATE mtl_serial_numbers
1488: SET inspection_status = p_inspection_status
1489: , lot_number = p_lot_number
1490: , revision = p_revision
1491: , current_organization_id = p_organization_id

Line 1500: UPDATE mtl_serial_numbers

1496: , planning_tp_type = NVL(p_planning_tp_type, 2)
1497: WHERE serial_number = l_cur_serial_number
1498: AND inventory_item_id = p_inventory_item_id;
1499: ELSE
1500: UPDATE mtl_serial_numbers
1501: SET lot_number = p_lot_number
1502: , revision = p_revision
1503: WHERE serial_number = l_cur_serial_number
1504: AND inventory_item_id = p_inventory_item_id

Line 1676: FROM mtl_serial_numbers_temp

1672: , n_attribute8
1673: , n_attribute9
1674: , n_attribute10
1675: , territory_code
1676: FROM mtl_serial_numbers_temp
1677: WHERE transaction_temp_id = p_serial_temp_id
1678: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
1679:
1680: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 1851: UPDATE mtl_serial_numbers

1847: -- invtrace('n_attribute10 ' || l_n_attribute10);
1848: -- invtrace('territory_code ' || l_territory_code);
1849: -- invtrace('cost_group_id ' || inv_cost_group_pub.g_cost_group_id);
1850:
1851: UPDATE mtl_serial_numbers
1852: SET current_status = decode(p_current_status, null,
1853: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_status)),
1854: decode(p_wip_entity_id, null, p_current_status,decode(p_current_status, 6, 1, p_current_status)) )
1855: , initialization_date = initialization_date

Line 1935: UPDATE mtl_serial_numbers

1931: WHERE inventory_item_id = p_inventory_item_id
1932: AND serial_number = p_serial_number
1933: AND DECODE(current_status, 6, 1, current_status) = DECODE(p_last_status, 6, 1, p_last_status);
1934: ELSE
1935: UPDATE mtl_serial_numbers
1936: SET current_status = decode(p_current_status, null,
1937: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_Status)),
1938: decode(p_wip_entity_id, null, p_current_status, decode(p_current_status, 6, 1, p_current_status)))
1939: , initialization_date = initialization_date

Line 1999: UPDATE mtl_serial_numbers

1995: -- invtrace(' last_update_date ' || SYSDATE);
1996: -- invtrace(' last_updated_by ' || l_userid);
1997: -- invtrace(' parent_item_id ' || p_parent_item_id);
1998: -- invtrace(' parent_serial_number ' || p_parent_serial_number);
1999: UPDATE mtl_serial_numbers
2000: SET current_status = decode(p_current_status, null,
2001: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_Status)),
2002: decode(p_wip_entity_id, null, p_current_status, decode(p_current_status, 6, 1, p_current_status)))
2003: , initialization_date = initialization_date

Line 2165: FROM mtl_serial_numbers_temp

2161: , TO_CHAR(n_attribute9)
2162: , TO_CHAR(n_attribute10)
2163: , status_id
2164: , territory_code
2165: FROM mtl_serial_numbers_temp
2166: WHERE transaction_temp_id = p_transaction_temp_id
2167: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2168: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2169:

Line 2278: , p_table_name => 'MTL_SERIAL_NUMBERS'

2274: , x_attributes_default_count => l_attributes_default_count
2275: , x_return_status => l_return_status
2276: , x_msg_count => l_msg_count
2277: , x_msg_data => l_msg_data
2278: , p_table_name => 'MTL_SERIAL_NUMBERS'
2279: , p_attributes_name => 'Serial Attributes'
2280: , p_inventory_item_id => p_inventory_item_id
2281: , p_organization_id => p_organization_id
2282: , p_lot_serial_number => p_serial_number

Line 2461: FROM mtl_serial_numbers

2457: , cycles_since_visit
2458: , time_since_mark
2459: , cycles_since_mark
2460: , number_of_repairs
2461: FROM mtl_serial_numbers
2462: WHERE serial_number = p_serial_number
2463: AND current_organization_id = p_organization_id
2464: AND inventory_item_id = p_inventory_item_id;
2465: /* Bug 2207912 */

Line 2479: -- from mtl_serial_numbers sn

2475: ** So the insert statement will always fail.
2476: */
2477: --and not exists
2478: -- ( select NULL
2479: -- from mtl_serial_numbers sn
2480: -- where sn.serial_number = p_serial_number
2481: -- and sn.current_organization_id = p_organization_id
2482: -- and sn.inventory_item_id = p_inventory_item_id);
2483: ELSE

Line 2706: FROM mtl_serial_numbers_temp

2702: , attribute12
2703: , attribute13
2704: , attribute14
2705: , attribute15
2706: FROM mtl_serial_numbers_temp
2707: WHERE transaction_temp_id = p_transaction_temp_id
2708: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2709: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2710: ELSE

Line 2860: FROM mtl_serial_numbers msn

2856: , msn.cycles_since_visit
2857: , msn.time_since_mark
2858: , msn.cycles_since_mark
2859: , msn.number_of_repairs
2860: FROM mtl_serial_numbers msn
2861: WHERE inventory_item_id = p_inventory_item_id
2862: AND serial_number = p_serial_number;
2863: END IF;
2864: END IF;

Line 2877: UPDATE mtl_serial_numbers

2873: p_inventory_item_id);
2874: END IF;
2875:
2876: BEGIN
2877: UPDATE mtl_serial_numbers
2878: SET serial_attribute_category = g_serial_attributes_tbl(1).column_value
2879: , origination_date = l_date2
2880: , c_attribute1 = g_serial_attributes_tbl(3).column_value
2881: , c_attribute2 = g_serial_attributes_tbl(4).column_value

Line 3431: p_table_name => 'MTL_SERIAL_NUMBERS',

3427: x_attributes_default_count => l_attributes_default_count,
3428: x_return_status => l_return_status,
3429: x_msg_count => l_msg_count,
3430: x_msg_data => x_msg_data,
3431: p_table_name => 'MTL_SERIAL_NUMBERS',
3432: p_attributes_name => 'Serial Attributes',
3433: p_inventory_item_id => p_inventory_item_id,
3434: p_organization_id => p_organization_id,
3435: p_lot_serial_number => p_serial_number,

Line 3637: UPDATE mtl_serial_numbers

3633: END IF;
3634:
3635: IF l_validation_status = 'Y' THEN
3636: IF NOT p_validate_only THEN
3637: UPDATE mtl_serial_numbers
3638: SET serial_attribute_category = g_serial_attributes_tbl(1).COLUMN_VALUE
3639: , origination_date = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(2).COLUMN_VALUE))
3640: , c_attribute1 = g_serial_attributes_tbl(3).COLUMN_VALUE
3641: , c_attribute2 = g_serial_attributes_tbl(4).COLUMN_VALUE

Line 3898: FROM mtl_serial_numbers

3894: END IF;
3895:
3896: SELECT current_status
3897: INTO l_last_status
3898: FROM mtl_serial_numbers
3899: WHERE inventory_item_id = p_invitemid
3900: AND serial_number = p_f_ser_num;
3901:
3902: IF (l_debug = 1) THEN

Line 3965: UPDATE MTL_SERIAL_NUMBERS MSN

3961: invtrace('After call fnd_date.canonical_to_date');
3962: END IF;
3963:
3964: if( l_to_status in (1, 6) ) THEN
3965: UPDATE MTL_SERIAL_NUMBERS MSN
3966: SET msn.current_status = l_to_status,
3967: msn.initialization_date = l_init_date,
3968: msn.completion_date = null,
3969: msn.SHIP_DATE = NULL,

Line 4036: UPDATE MTL_SERIAL_NUMBERS msn

4032: IF (l_debug = 1) THEN
4033: invtrace( 'To Status not in 1,6');
4034: END IF;
4035:
4036: UPDATE MTL_SERIAL_NUMBERS msn
4037: SET
4038: msn.CURRENT_STATUS = l_to_status, -- p_current_status,
4039: msn.COMPLETION_DATE = NVL( msn.COMPLETION_DATE, p_trxdate ),
4040: msn.SHIP_DATE = DECODE( l_to_status, 3, NULL, NVL( msn.SHIP_DATE, p_trxdate ) ),

Line 4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;

4797: l_return_status VARCHAR2(1);
4798: l_msg_data VARCHAR2(2000);
4799: l_msg_count NUMBER;
4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

Line 4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;

4798: l_msg_data VARCHAR2(2000);
4799: l_msg_count NUMBER;
4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

Line 4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;

4799: l_msg_count NUMBER;
4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

Line 4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;

4800: l_upd_count NUMBER;
4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

Line 4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

4801: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

Line 4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

4802: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

Line 4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

4803: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

Line 4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

4804: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:

Line 4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

4805: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:
4813:

Line 4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

4806: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:
4813:
4814: l_sys_date date := NULL;

Line 4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

4807: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
4808: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
4809: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
4810: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
4811: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
4812:
4813:
4814: l_sys_date date := NULL;
4815: l_date2 date := NULL;

Line 4894: from mtl_serial_numbers_temp

4890: , CYCLES_SINCE_VISIT
4891: , TIME_SINCE_MARK
4892: , CYCLES_SINCE_MARK
4893: , NUMBER_OF_REPAIRS
4894: from mtl_serial_numbers_temp
4895: where transaction_temp_id = p_transaction_temp_id
4896: and fm_serial_number = p_fm_serial_number and to_serial_number = p_to_serial_number;
4897: l_input_idx BINARY_INTEGER;
4898:

Line 5048: , p_table_name => 'MTL_SERIAL_NUMBERS'

5044: , x_attributes_default_count => l_attributes_default_count
5045: , x_return_status => l_return_status
5046: , x_msg_count => l_msg_count
5047: , x_msg_data => l_msg_data
5048: , p_table_name => 'MTL_SERIAL_NUMBERS'
5049: , p_attributes_name => 'Serial Attributes'
5050: , p_inventory_item_id => p_inventory_item_id
5051: , p_organization_id => p_organization_id
5052: , p_lot_serial_number => p_fm_serial_number

Line 5234: FROM mtl_serial_numbers msn

5230: , msn.cycles_since_visit
5231: , msn.time_since_mark
5232: , msn.cycles_since_mark
5233: , msn.number_of_repairs
5234: FROM mtl_serial_numbers msn
5235: WHERE msn.serial_number between p_fm_serial_number and p_to_serial_number
5236: AND msn.current_organization_id = p_organization_id
5237: AND msn.inventory_item_id = p_inventory_item_id;
5238: /* Bug 2207912 */

Line 5252: -- from mtl_serial_numbers sn

5248: ** So the insert statement will always fail.
5249: */
5250: --and not exists
5251: -- ( select NULL
5252: -- from mtl_serial_numbers sn
5253: -- where sn.serial_number = p_serial_number
5254: -- and sn.current_organization_id = p_organization_id
5255: -- and sn.inventory_item_id = p_inventory_item_id);
5256: ELSE

Line 5303: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

5299: -- anywhere. for performance reason.
5300: /*****
5301: SELECT count(*)
5302: into l_upd_count
5303: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
5304: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5305: AND lpad(msn.serial_number, 30) between lpad(msnt.fm_serial_number,30) AND LPAD(NVL(msnt.to_serial_number, msnt.fm_serial_number),30)
5306: AND Lpad(msnt.fm_serial_number,30) = l_fm_serial_number
5307: AND Lpad(msnt.to_serial_number,30) = l_to_serial_number;

Line 5511: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

5507: , msnt.attribute12
5508: , msnt.attribute13
5509: , msnt.attribute14
5510: , msnt.attribute15
5511: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
5512: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5513: AND msn.current_organization_id = p_organization_id
5514: AND msn.inventory_item_id = p_inventory_item_id
5515: AND lpad(msn.serial_number,30) between lpad(msnt.fm_serial_number,30) AND lpad(msnt.to_serial_number,30)

Line 5717: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

5713: , msnt.attribute12
5714: , msnt.attribute13
5715: , msnt.attribute14
5716: , msnt.attribute15
5717: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
5718: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5719: AND msn.current_organization_id = p_organization_id
5720: AND msn.inventory_item_id = p_inventory_item_id
5721: AND lpad(msn.serial_number,30) = lpad(msnt.fm_serial_number,30)

Line 5881: FROM mtl_serial_numbers msn

5877: , l_cycles_since_visit
5878: , l_time_since_mark
5879: , l_cycles_since_mark
5880: , l_number_of_repairs
5881: FROM mtl_serial_numbers msn
5882: WHERE inventory_item_id = p_inventory_item_id
5883: AND serial_number between p_fm_serial_number AND p_to_serial_number;
5884: END IF;
5885: END IF;

Line 5897: UPDATE mtl_serial_numbers

5893: || ' org _id ' || p_organization_id || 'item ' ||
5894: p_inventory_item_id);
5895: END IF;
5896: BEGIN
5897: UPDATE mtl_serial_numbers
5898: SET serial_attribute_category = g_serial_attributes_tbl(1).column_value
5899: , origination_date = l_date2
5900: , c_attribute1 = g_serial_attributes_tbl(3).column_value
5901: , c_attribute2 = g_serial_attributes_tbl(4).column_value