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 285: INSERT INTO mtl_serial_numbers

281: l_loginid := fnd_global.login_id;
282: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, p_serial_number, x_msg_data);
283:
284: IF (isunique = 0) THEN
285: INSERT INTO mtl_serial_numbers
286: (
287: inventory_item_id
288: , serial_number
289: , last_update_date

Line 472: FROM mtl_serial_numbers_temp

468: , TO_CHAR(n_attribute9)
469: , TO_CHAR(n_attribute10)
470: , status_id
471: , territory_code
472: FROM mtl_serial_numbers_temp
473: WHERE transaction_temp_id = p_transaction_temp_id
474: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
475:
476: l_input_idx BINARY_INTEGER;

Line 627: , p_table_name => 'MTL_SERIAL_NUMBERS'

623: , x_attributes_default_count => l_attributes_default_count
624: , x_return_status => l_return_status
625: , x_msg_count => l_msg_count
626: , x_msg_data => l_msg_data
627: , p_table_name => 'MTL_SERIAL_NUMBERS'
628: , p_attributes_name => 'Serial Attributes'
629: , p_inventory_item_id => p_inventory_item_id
630: , p_organization_id => p_organization_id
631: , p_lot_serial_number => p_serial_number

Line 660: INSERT INTO mtl_serial_numbers

656: IF (p_transaction_action_id = 3
657: AND g_firstscan = FALSE) THEN
658: -- invtrace(' inserting into MSN values ');
659: ---------#-#-#-#get the values later
660: INSERT INTO mtl_serial_numbers
661: (
662: inventory_item_id
663: , serial_number
664: , last_update_date

Line 879: FROM mtl_serial_numbers

875: , NVL(p_planning_tp_type, 2)
876: , wip_entity_id
877: , operation_seq_num
878: , intraoperation_step_type
879: FROM mtl_serial_numbers
880: WHERE serial_number = p_serial_number
881: AND current_organization_id = g_transfer_org_id
882: AND inventory_item_id = p_inventory_item_id
883: AND NOT EXISTS(

Line 885: FROM mtl_serial_numbers sn

881: AND current_organization_id = g_transfer_org_id
882: AND inventory_item_id = p_inventory_item_id
883: AND NOT EXISTS(
884: SELECT NULL
885: FROM mtl_serial_numbers sn
886: WHERE sn.serial_number = p_serial_number
887: AND sn.current_organization_id = p_organization_id
888: AND sn.inventory_item_id = p_inventory_item_id);
889:

Line 894: FROM mtl_serial_numbers

890: -- prepare to insert the initial status to the status history table
891: -- bug 1870120
892: SELECT status_id
893: INTO l_status_id
894: FROM mtl_serial_numbers
895: WHERE serial_number = p_serial_number
896: AND current_organization_id = p_organization_id
897: AND inventory_item_id = p_inventory_item_id;
898: -- 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 940: INSERT INTO mtl_serial_numbers

936: l_status_id := p_status_id;
937: END IF;
938:
939: -- invtrace('inserting into MSN values');
940: INSERT INTO mtl_serial_numbers
941: (
942: inventory_item_id
943: , serial_number
944: , last_update_date

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

1482: -- get the number part of the from serial
1483: inv_validate.number_from_sequence(p_fm_serial_number, l_temp_prefix, l_from_ser_number);
1484: -- get the number part of the to serial
1485: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
1486: -- total number of serials inserted into mtl_serial_numbers
1487: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1488: --bug10074682,from serial number and to serial number shoule be in sequence.
1489: IF l_range_numbers < 1 THEN --the range numbers with no sense,need enter the validate range nubmers
1490: fnd_message.set_name('INV','INVALID_SERIAL_NUMBER'); --error messag

Line 1512: INSERT INTO mtl_serial_numbers

1508: SELECT mtl_gen_object_id_s.NEXTVAL
1509: INTO x_object_id
1510: FROM DUAL;
1511:
1512: INSERT INTO mtl_serial_numbers
1513: (
1514: inventory_item_id
1515: , serial_number
1516: , last_update_date

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

1661: -- get the number part of the from serial
1662: inv_validate.number_from_sequence(p_from_serial_number, l_temp_prefix, l_from_ser_number);
1663: -- get the number part of the to serial
1664: inv_validate.number_from_sequence(p_to_serial_number, l_temp_prefix, l_to_ser_number);
1665: -- total number of serials inserted into mtl_serial_numbers
1666: l_range_numbers := l_to_ser_number - l_from_ser_number + 1;
1667:
1668: FOR i IN 1 .. l_range_numbers LOOP
1669: l_cur_ser_number := l_from_ser_number + i - 1;

Line 1686: FROM mtl_serial_numbers

1682: SELECT current_status, previous_status -- 13564609
1683: , NVL(group_mark_id, -1)
1684: INTO l_current_status, l_previous_status -- 13564609
1685: , l_group_mark_id
1686: FROM mtl_serial_numbers
1687: WHERE serial_number = l_cur_serial_number
1688: AND inventory_item_id = p_inventory_item_id;
1689: EXCEPTION
1690: WHEN NO_DATA_FOUND THEN

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

1707: OR(l_current_status = 6
1708: AND l_group_mark_id = -1) THEN
1709:
1710: -- Bug 5385315, Update the current_organization_id to p_organization_id
1711: -- in mtl_serial_numbers while updating the current_status from 4 to 1.
1712:
1713: IF (p_current_status = 1 AND l_current_status = 4) THEN
1714: -- pre-defined serial, update status
1715: UPDATE mtl_serial_numbers

Line 1715: UPDATE mtl_serial_numbers

1711: -- in mtl_serial_numbers while updating the current_status from 4 to 1.
1712:
1713: IF (p_current_status = 1 AND l_current_status = 4) THEN
1714: -- pre-defined serial, update status
1715: UPDATE mtl_serial_numbers
1716: SET current_status = p_current_status
1717: , inspection_status = p_inspection_status
1718: , lpn_id = null --bug 5152103
1719: , current_organization_id = p_organization_id

Line 1727: UPDATE mtl_serial_numbers

1723: WHERE serial_number = l_cur_serial_number
1724: AND inventory_item_id = p_inventory_item_id;
1725: ELSE
1726: -- pre-defined serial, update status
1727: UPDATE mtl_serial_numbers
1728: SET current_status = p_current_status
1729: , inspection_status = p_inspection_status
1730: -- , lpn_id = decode(p_current_status,1,decode(current_status,4,null,lpn_id),lpn_id) --bug 5152103
1731: , last_updated_by = fnd_global.user_id -- 13564609

Line 1818: UPDATE mtl_serial_numbers

1814: * If WMS or PO J are not installed or this API is called from other
1815: * routines, then updates to the serial number are retained
1816: */
1817: IF (NVL(p_rcv_serial_flag, 'N') <> 'Y') THEN
1818: UPDATE mtl_serial_numbers
1819: SET inspection_status = p_inspection_status
1820: , lot_number = p_lot_number
1821: , revision = p_revision
1822: , current_organization_id = p_organization_id

Line 1831: UPDATE mtl_serial_numbers

1827: , planning_tp_type = NVL(p_planning_tp_type, 2)
1828: WHERE serial_number = l_cur_serial_number
1829: AND inventory_item_id = p_inventory_item_id;
1830: ELSE
1831: UPDATE mtl_serial_numbers
1832: SET lot_number = p_lot_number
1833: , revision = p_revision
1834: WHERE serial_number = l_cur_serial_number
1835: AND inventory_item_id = p_inventory_item_id

Line 2007: FROM mtl_serial_numbers_temp

2003: , n_attribute8
2004: , n_attribute9
2005: , n_attribute10
2006: , territory_code
2007: FROM mtl_serial_numbers_temp
2008: WHERE transaction_temp_id = p_serial_temp_id
2009: AND p_serial_number BETWEEN fm_serial_number AND NVL(to_serial_number, fm_serial_number);
2010:
2011: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 2182: UPDATE mtl_serial_numbers

2178: -- invtrace('n_attribute10 ' || l_n_attribute10);
2179: -- invtrace('territory_code ' || l_territory_code);
2180: -- invtrace('cost_group_id ' || inv_cost_group_pub.g_cost_group_id);
2181:
2182: UPDATE mtl_serial_numbers
2183: SET current_status = decode(p_current_status, null,
2184: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_status)),
2185: decode(p_wip_entity_id, null, p_current_status,decode(p_current_status, 6, 1, p_current_status)) )
2186: , initialization_date = initialization_date

Line 2266: UPDATE mtl_serial_numbers

2262: WHERE inventory_item_id = p_inventory_item_id
2263: AND serial_number = p_serial_number
2264: AND DECODE(current_status, 6, 1, current_status) = DECODE(p_last_status, 6, 1, p_last_status);
2265: ELSE
2266: UPDATE mtl_serial_numbers
2267: SET current_status = decode(p_current_status, null,
2268: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_Status)),
2269: decode(p_wip_entity_id, null, p_current_status, decode(p_current_status, 6, 1, p_current_status)))
2270: , initialization_date = initialization_date

Line 2330: UPDATE mtl_serial_numbers

2326: -- invtrace(' last_update_date ' || SYSDATE);
2327: -- invtrace(' last_updated_by ' || l_userid);
2328: -- invtrace(' parent_item_id ' || p_parent_item_id);
2329: -- invtrace(' parent_serial_number ' || p_parent_serial_number);
2330: UPDATE mtl_serial_numbers
2331: SET current_status = decode(p_current_status, null,
2332: decode(p_wip_entity_id, null, current_status, decode(current_status, 6, 1, current_Status)),
2333: decode(p_wip_entity_id, null, p_current_status, decode(p_current_status, 6, 1, p_current_status)))
2334: , initialization_date = initialization_date

Line 2496: FROM mtl_serial_numbers_temp

2492: , TO_CHAR(n_attribute9)
2493: , TO_CHAR(n_attribute10)
2494: , status_id
2495: , territory_code
2496: FROM mtl_serial_numbers_temp
2497: WHERE transaction_temp_id = p_transaction_temp_id
2498: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
2499: /* Bug 3622025 -- Added the LPAD function in the above where clause */
2500:

Line 2609: , p_table_name => 'MTL_SERIAL_NUMBERS'

2605: , x_attributes_default_count => l_attributes_default_count
2606: , x_return_status => l_return_status
2607: , x_msg_count => l_msg_count
2608: , x_msg_data => l_msg_data
2609: , p_table_name => 'MTL_SERIAL_NUMBERS'
2610: , p_attributes_name => 'Serial Attributes'
2611: , p_inventory_item_id => p_inventory_item_id
2612: , p_organization_id => p_organization_id
2613: , p_lot_serial_number => p_serial_number

Line 2792: FROM mtl_serial_numbers

2788: , cycles_since_visit
2789: , time_since_mark
2790: , cycles_since_mark
2791: , number_of_repairs
2792: FROM mtl_serial_numbers
2793: WHERE serial_number = p_serial_number
2794: AND current_organization_id = p_organization_id
2795: AND inventory_item_id = p_inventory_item_id;
2796: /* Bug 2207912 */

Line 2810: -- from mtl_serial_numbers sn

2806: ** So the insert statement will always fail.
2807: */
2808: --and not exists
2809: -- ( select NULL
2810: -- from mtl_serial_numbers sn
2811: -- where sn.serial_number = p_serial_number
2812: -- and sn.current_organization_id = p_organization_id
2813: -- and sn.inventory_item_id = p_inventory_item_id);
2814: ELSE

Line 3037: FROM mtl_serial_numbers_temp

3033: , attribute12
3034: , attribute13
3035: , attribute14
3036: , attribute15
3037: FROM mtl_serial_numbers_temp
3038: WHERE transaction_temp_id = p_transaction_temp_id
3039: AND LPAD(p_serial_number,30) BETWEEN LPAD(fm_serial_number,30) AND LPAD(NVL(to_serial_number, fm_serial_number),30);
3040: /* Bug 3622025 -- Added the LPAD function in the above where clause */
3041: ELSE

Line 3191: FROM mtl_serial_numbers msn

3187: , msn.cycles_since_visit
3188: , msn.time_since_mark
3189: , msn.cycles_since_mark
3190: , msn.number_of_repairs
3191: FROM mtl_serial_numbers msn
3192: WHERE inventory_item_id = p_inventory_item_id
3193: AND serial_number = p_serial_number;
3194: END IF;
3195: END IF;

Line 3208: UPDATE mtl_serial_numbers

3204: p_inventory_item_id);
3205: END IF;
3206:
3207: BEGIN
3208: UPDATE mtl_serial_numbers
3209: SET serial_attribute_category = g_serial_attributes_tbl(1).column_value
3210: , origination_date = l_date2
3211: , c_attribute1 = g_serial_attributes_tbl(3).column_value
3212: , c_attribute2 = g_serial_attributes_tbl(4).column_value

Line 3796: p_table_name => 'MTL_SERIAL_NUMBERS',

3792: x_attributes_default_count => l_attributes_default_count,
3793: x_return_status => l_return_status,
3794: x_msg_count => l_msg_count,
3795: x_msg_data => x_msg_data,
3796: p_table_name => 'MTL_SERIAL_NUMBERS',
3797: p_attributes_name => 'Serial Attributes',
3798: p_inventory_item_id => p_inventory_item_id,
3799: p_organization_id => p_organization_id,
3800: p_lot_serial_number => p_serial_number,

Line 4002: UPDATE mtl_serial_numbers

3998: END IF;
3999:
4000: IF l_validation_status = 'Y' THEN
4001: IF NOT p_validate_only THEN
4002: UPDATE mtl_serial_numbers
4003: SET serial_attribute_category = g_serial_attributes_tbl(1).COLUMN_VALUE
4004: , origination_date = fnd_date.canonical_to_date(fnd_date.date_to_canonical(g_serial_attributes_tbl(2).COLUMN_VALUE))
4005: , c_attribute1 = g_serial_attributes_tbl(3).COLUMN_VALUE
4006: , c_attribute2 = g_serial_attributes_tbl(4).COLUMN_VALUE

Line 4281: FROM mtl_serial_numbers

4277: END IF;
4278:
4279: SELECT current_status
4280: INTO l_last_status
4281: FROM mtl_serial_numbers
4282: WHERE inventory_item_id = p_invitemid
4283: AND serial_number = p_f_ser_num;
4284:
4285: IF (l_debug = 1) THEN

Line 4348: UPDATE MTL_SERIAL_NUMBERS MSN

4344: invtrace('After call fnd_date.canonical_to_date');
4345: END IF;
4346:
4347: if( l_to_status in (1, 6) ) THEN
4348: UPDATE MTL_SERIAL_NUMBERS MSN
4349: SET msn.current_status = l_to_status,
4350: msn.initialization_date = l_init_date,
4351: msn.completion_date = null,
4352: msn.SHIP_DATE = NULL,

Line 4421: UPDATE MTL_SERIAL_NUMBERS msn

4417: IF (l_debug = 1) THEN
4418: invtrace( 'To Status not in 1,6');
4419: END IF;
4420:
4421: UPDATE MTL_SERIAL_NUMBERS msn
4422: SET
4423: msn.CURRENT_STATUS = l_to_status, -- p_current_status,
4424: msn.COMPLETION_DATE = NVL( msn.COMPLETION_DATE, p_trxdate ),
4425: msn.SHIP_DATE = DECODE( l_to_status, 3, NULL, NVL( msn.SHIP_DATE, p_trxdate ) ),

Line 5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;

5184: l_return_status VARCHAR2(1);
5185: l_msg_data VARCHAR2(2000);
5186: l_msg_count NUMBER;
5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

Line 5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;

5185: l_msg_data VARCHAR2(2000);
5186: l_msg_count NUMBER;
5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

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

5186: l_msg_count NUMBER;
5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

Line 5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;

5187: l_upd_count NUMBER;
5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

Line 5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;

5188: l_TIME_SINCE_NEW mtl_serial_numbers_temp.TIME_SINCE_NEW%type;
5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

Line 5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;

5189: l_CYCLES_SINCE_NEW mtl_serial_numbers_temp.CYCLES_SINCE_NEW%type;
5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

Line 5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;

5190: l_TIME_SINCE_OVERHAUL mtl_serial_numbers_temp.TIME_SINCE_OVERHAUL%type := NULL;
5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

Line 5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;

5191: l_CYCLES_SINCE_OVERHAUL mtl_serial_numbers_temp.CYCLES_SINCE_OVERHAUL%type;
5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:

Line 5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;

5192: l_TIME_SINCE_REPAIR mtl_serial_numbers_temp.TIME_SINCE_REPAIR%type;
5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:
5200:

Line 5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;

5193: l_CYCLES_SINCE_REPAIR mtl_serial_numbers_temp.CYCLES_SINCE_REPAIR%type;
5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:
5200:
5201: l_sys_date date := NULL;

Line 5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;

5194: l_TIME_SINCE_VISIT mtl_serial_numbers_temp.TIME_SINCE_VISIT%type;
5195: l_CYCLES_SINCE_VISIT mtl_serial_numbers_temp.CYCLES_SINCE_VISIT%type;
5196: l_TIME_SINCE_MARK mtl_serial_numbers_temp.TIME_SINCE_MARK%type;
5197: l_CYCLES_SINCE_MARK mtl_serial_numbers_temp.CYCLES_SINCE_MARK%type;
5198: l_NUMBER_OF_REPAIRS mtl_serial_numbers_temp.NUMBER_OF_REPAIRS%type;
5199:
5200:
5201: l_sys_date date := NULL;
5202: l_date2 date := NULL;

Line 5281: from mtl_serial_numbers_temp

5277: , CYCLES_SINCE_VISIT
5278: , TIME_SINCE_MARK
5279: , CYCLES_SINCE_MARK
5280: , NUMBER_OF_REPAIRS
5281: from mtl_serial_numbers_temp
5282: where transaction_temp_id = p_transaction_temp_id
5283: and fm_serial_number = p_fm_serial_number and to_serial_number = p_to_serial_number;
5284: l_input_idx BINARY_INTEGER;
5285:

Line 5435: , p_table_name => 'MTL_SERIAL_NUMBERS'

5431: , x_attributes_default_count => l_attributes_default_count
5432: , x_return_status => l_return_status
5433: , x_msg_count => l_msg_count
5434: , x_msg_data => l_msg_data
5435: , p_table_name => 'MTL_SERIAL_NUMBERS'
5436: , p_attributes_name => 'Serial Attributes'
5437: , p_inventory_item_id => p_inventory_item_id
5438: , p_organization_id => p_organization_id
5439: , p_lot_serial_number => p_fm_serial_number

Line 5621: FROM mtl_serial_numbers msn

5617: , msn.cycles_since_visit
5618: , msn.time_since_mark
5619: , msn.cycles_since_mark
5620: , msn.number_of_repairs
5621: FROM mtl_serial_numbers msn
5622: WHERE msn.serial_number between p_fm_serial_number and p_to_serial_number
5623: AND msn.current_organization_id = p_organization_id
5624: AND msn.inventory_item_id = p_inventory_item_id;
5625: /* Bug 2207912 */

Line 5639: -- from mtl_serial_numbers sn

5635: ** So the insert statement will always fail.
5636: */
5637: --and not exists
5638: -- ( select NULL
5639: -- from mtl_serial_numbers sn
5640: -- where sn.serial_number = p_serial_number
5641: -- and sn.current_organization_id = p_organization_id
5642: -- and sn.inventory_item_id = p_inventory_item_id);
5643: ELSE

Line 5690: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

5686: -- anywhere. for performance reason.
5687: /*****
5688: SELECT count(*)
5689: into l_upd_count
5690: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
5691: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5692: 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)
5693: AND Lpad(msnt.fm_serial_number,30) = l_fm_serial_number
5694: AND Lpad(msnt.to_serial_number,30) = l_to_serial_number;

Line 5898: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

5894: , msnt.attribute12
5895: , msnt.attribute13
5896: , msnt.attribute14
5897: , msnt.attribute15
5898: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
5899: WHERE msnt.transaction_temp_id = p_transaction_temp_id
5900: AND msn.current_organization_id = p_organization_id
5901: AND msn.inventory_item_id = p_inventory_item_id
5902: AND lpad(msn.serial_number,30) between lpad(msnt.fm_serial_number,30) AND lpad(msnt.to_serial_number,30)

Line 6104: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn

6100: , msnt.attribute12
6101: , msnt.attribute13
6102: , msnt.attribute14
6103: , msnt.attribute15
6104: FROM mtl_serial_numbers_temp msnt, mtl_serial_numbers msn
6105: WHERE msnt.transaction_temp_id = p_transaction_temp_id
6106: AND msn.current_organization_id = p_organization_id
6107: AND msn.inventory_item_id = p_inventory_item_id
6108: AND lpad(msn.serial_number,30) = lpad(msnt.fm_serial_number,30)

Line 6268: FROM mtl_serial_numbers msn

6264: , l_cycles_since_visit
6265: , l_time_since_mark
6266: , l_cycles_since_mark
6267: , l_number_of_repairs
6268: FROM mtl_serial_numbers msn
6269: WHERE inventory_item_id = p_inventory_item_id
6270: AND serial_number between p_fm_serial_number AND p_to_serial_number;
6271: END IF;
6272: END IF;

Line 6284: UPDATE mtl_serial_numbers

6280: || ' org _id ' || p_organization_id || 'item ' ||
6281: p_inventory_item_id);
6282: END IF;
6283: BEGIN
6284: UPDATE mtl_serial_numbers
6285: SET serial_attribute_category = g_serial_attributes_tbl(1).column_value
6286: , origination_date = l_date2
6287: , c_attribute1 = g_serial_attributes_tbl(3).column_value
6288: , c_attribute2 = g_serial_attributes_tbl(4).column_value