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

Line 140: l_epc_sql := l_epc_sql || ' FROM mtl_serial_numbers_temp';

136:
137: dbms_sql.close_cursor(l_epc_cursor);
138: ELSE --Serial
139: l_epc_sql := 'SELECT ' || l_epc_column;
140: l_epc_sql := l_epc_sql || ' FROM mtl_serial_numbers_temp';
141: l_epc_sql := l_epc_sql || ' WHERE rowid = :row_id';
142:
143: IF (l_debug = 1) THEN
144: print_debug('l_epc_sql: '||l_epc_sql,4);

Line 585: mtl_serial_numbers_temp msnt

581: ,msnt.time_since_mark time_since_mark
582: ,msnt.cycles_since_mark cycles_since_mark
583: ,msnt.number_of_repairs number_of_repairs
584: from
585: mtl_serial_numbers_temp msnt
586: ,rcv_transactions_interface rti
587: where
588: msnt.product_code = 'RCV'
589: AND msnt.product_transaction_id = p_prod_txn_tmp_id

Line 1057: DELETE FROM mtl_serial_numbers_temp

1053: AND product_transaction_id = p_prod_txn_tmp_id;
1054:
1055: l_progress := 'WMSINB-10883';
1056:
1057: DELETE FROM mtl_serial_numbers_temp
1058: WHERE product_code = 'RCV'
1059: AND product_transaction_id = p_prod_txn_tmp_id;
1060:
1061: IF (l_debug = 1) THEN

Line 1608: UPDATE mtl_serial_numbers

1604: END IF;
1605:
1606: IF l_serials_count > 0 THEN
1607:
1608: UPDATE mtl_serial_numbers
1609: SET current_status = 1,
1610: group_mark_id = NULL,
1611: line_mark_id = NULL,
1612: lot_line_mark_id = NULL

Line 1743: FROM mtl_serial_numbers_temp

1739: BEGIN
1740: l_progress := 'WMSINB-11324';
1741: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
1742: INTO l_total_ser_qty
1743: FROM mtl_serial_numbers_temp
1744: WHERE product_code = p_product_code
1745: AND product_transaction_id = p_product_txn_id;
1746: END;
1747: End if;

Line 1771: from mtl_serial_numbers_temp msnt

1767: l_progress := 'WMSINB-11351';
1768: For l_serial_rec in ( select fm_serial_number
1769: , to_serial_number
1770: , inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1771: from mtl_serial_numbers_temp msnt
1772: where msnt.transaction_temp_id = l_lot_rec.serial_transaction_temp_id
1773: and msnt.product_transaction_id = p_product_txn_id
1774: and msnt.product_code = 'RCV'
1775: )

Line 1888: from mtl_serial_numbers_temp msnt

1884: l_progress := 'WMSINB-11453';
1885: For l_serial_rec in ( select fm_serial_number
1886: ,to_serial_number
1887: ,inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1888: from mtl_serial_numbers_temp msnt
1889: where msnt.product_transaction_id = p_product_txn_id
1890: and msnt.product_code = 'RCV'
1891: )
1892: Loop

Line 2234: mtl_serial_numbers_interface

2230: SELECT
2231: fm_serial_number,
2232: to_serial_number
2233: FROM
2234: mtl_serial_numbers_interface
2235: WHERE l_intf_txn_id = transaction_interface_id;
2236:
2237: l_wlpnci_total_qty NUMBER;
2238: l_msni_total_qty NUMBER := 0;

Line 2703: UPDATE mtl_serial_numbers_interface

2699:
2700: -- Now update the product code and product_intf_id
2701: IF (l_msni_total_qty > 0) THEN
2702: BEGIN
2703: UPDATE mtl_serial_numbers_interface
2704: SET product_code = 'RCV',
2705: product_transaction_id=l_rti_rec.interface_transaction_id,
2706: transaction_interface_id = l_serial_txn_intf_id
2707: --WHERE transaction_interface_id = l_wlpnci_rec.interface_transaction_id;

Line 3220: from mtl_serial_numbers_temp

3216:
3217: --BUG 5008139 -- Getting the count of serial records in MSNT
3218: select count(*)
3219: into l_count
3220: from mtl_serial_numbers_temp
3221: where product_code = 'RCV'
3222: and product_transaction_id = p_product_txn_id;
3223:
3224: IF (l_debug = 1) THEN

Line 3286: update mtl_serial_numbers msn

3282: -- 'Resides in Stores' in the same session.
3283:
3284: -- Bug 7427382 Updating columns owning org and planning org also.
3285:
3286: update mtl_serial_numbers msn
3287: set msn.current_status = p_serial_status
3288: , inspection_status = p_inspection_status
3289: , group_mark_id = NULL
3290: , line_mark_id = decode(l_clear_line_mark_id, 1, NULL, line_mark_id)

Line 3303: from mtl_serial_numbers msn1

3299: -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3300: -- BUG 5611567
3301: msn.ROWID in (
3302: select msn1.ROWID
3303: from mtl_serial_numbers msn1
3304: , mtl_serial_numbers_temp msnt
3305: where msn1.inventory_item_id = p_item_id
3306: and msnt.product_code = 'RCV'
3307: and msnt.product_transaction_id = p_product_txn_id

Line 3304: , mtl_serial_numbers_temp msnt

3300: -- BUG 5611567
3301: msn.ROWID in (
3302: select msn1.ROWID
3303: from mtl_serial_numbers msn1
3304: , mtl_serial_numbers_temp msnt
3305: where msn1.inventory_item_id = p_item_id
3306: and msnt.product_code = 'RCV'
3307: and msnt.product_transaction_id = p_product_txn_id
3308: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 3317: -- update mtl_serial_numbers msn

3313:
3314: -- --BEGIN Bug: 5524134
3315: -- IF p_serial_status = -9999 THEN
3316: -- IF l_clear_line_mark_id = 1 THEN --{
3317: -- update mtl_serial_numbers msn
3318: -- set
3319: -- group_mark_id = NULL,
3320: -- line_mark_id = NULL,
3321: -- lot_line_mark_id = NULL

Line 3325: -- from mtl_serial_numbers_temp msnt

3321: -- lot_line_mark_id = NULL
3322: -- where msn.inventory_item_id = p_item_id
3323: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3324: -- and exists ( select 1
3325: -- from mtl_serial_numbers_temp msnt
3326: -- where msnt.product_code = 'RCV'
3327: -- and msnt.product_transaction_id = p_product_txn_id
3328: -- and msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number
3329: -- AND Length(msn.serial_number) = Length(msnt.fm_serial_number)

Line 3334: -- update mtl_serial_numbers msn

3330: -- AND length(msnt.fm_serial_number)=Length(Nvl(msnt.to_serial_number,msnt.fm_serial_number)) --BUG 3818544
3331: -- )
3332: -- ;
3333: -- ELSE --l_clear_line_mark_id = 1 }{
3334: -- update mtl_serial_numbers msn
3335: -- set
3336: -- group_mark_id = NULL
3337: -- where msn.inventory_item_id = p_item_id
3338: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail

Line 3340: -- from mtl_serial_numbers_temp msnt

3336: -- group_mark_id = NULL
3337: -- where msn.inventory_item_id = p_item_id
3338: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3339: -- and exists ( select 1
3340: -- from mtl_serial_numbers_temp msnt
3341: -- where msnt.product_code = 'RCV'
3342: -- and msnt.product_transaction_id = p_product_txn_id
3343: -- and msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number
3344: -- AND Length(msn.serial_number) = Length(msnt.fm_serial_number)

Line 3352: -- update mtl_serial_numbers msn

3348: -- END IF;--l_clear_line_mark_id = 1 }
3349: -- ELSE
3350: -- --END Bug: 5524134
3351: -- IF l_clear_line_mark_id = 1 THEN --{
3352: -- update mtl_serial_numbers msn
3353: -- set msn.current_status = p_serial_status
3354: -- , inspection_status = p_inspection_status
3355: -- , group_mark_id = NULL
3356: -- , line_mark_id = NULL

Line 3366: -- from mtl_serial_numbers msn1 ,

3362: -- -- msn.inventory_item_id = p_item_id
3363: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3364: -- -- BUG 5611567
3365: -- msn.ROWID in ( select msn1.ROWID
3366: -- from mtl_serial_numbers msn1 ,
3367: -- mtl_serial_numbers_temp msnt
3368: -- where msn1.inventory_item_id = p_item_id
3369: -- and msnt.product_code = 'RCV'
3370: -- and msnt.product_transaction_id = p_product_txn_id

Line 3367: -- mtl_serial_numbers_temp msnt

3363: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3364: -- -- BUG 5611567
3365: -- msn.ROWID in ( select msn1.ROWID
3366: -- from mtl_serial_numbers msn1 ,
3367: -- mtl_serial_numbers_temp msnt
3368: -- where msn1.inventory_item_id = p_item_id
3369: -- and msnt.product_code = 'RCV'
3370: -- and msnt.product_transaction_id = p_product_txn_id
3371: -- and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 3377: -- update mtl_serial_numbers msn

3373: -- AND length(msnt.fm_serial_number)=Length(nvl(msnt.to_serial_number,msnt.fm_serial_number)) --BUG 3818544
3374: -- )
3375: -- ;
3376: -- ELSE--l_clear_line_mark_id = 1 }{
3377: -- update mtl_serial_numbers msn
3378: -- set msn.current_status = p_serial_status
3379: -- , inspection_status = p_inspection_status
3380: -- , group_mark_id = NULL
3381: -- , current_organization_id = p_organization_id

Line 3389: -- from mtl_serial_numbers msn1 ,

3385: -- -- msn.inventory_item_id = p_item_id
3386: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3387: -- -- BUG 5611567
3388: -- msn.ROWID in ( select msn1.ROWID
3389: -- from mtl_serial_numbers msn1 ,
3390: -- mtl_serial_numbers_temp msnt
3391: -- where msn1.inventory_item_id = p_item_id
3392: -- and msnt.product_code = 'RCV'
3393: -- and msnt.product_transaction_id = p_product_txn_id

Line 3390: -- mtl_serial_numbers_temp msnt

3386: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3387: -- -- BUG 5611567
3388: -- msn.ROWID in ( select msn1.ROWID
3389: -- from mtl_serial_numbers msn1 ,
3390: -- mtl_serial_numbers_temp msnt
3391: -- where msn1.inventory_item_id = p_item_id
3392: -- and msnt.product_code = 'RCV'
3393: -- and msnt.product_transaction_id = p_product_txn_id
3394: -- and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 5210: -- FROM mtl_serial_numbers_temp

5206: -- ELSIF p_serial_number_control_code IN (2,5,6) THEN
5207: -- BEGIN
5208: -- SELECT '1'
5209: -- INTO l_dummy
5210: -- FROM mtl_serial_numbers_temp
5211: -- WHERE product_code = 'RCV'
5212: -- AND product_transaction_id = p_rti_id
5213: -- AND ROWNUM < 2;
5214: -- EXCEPTION

Line 6338: -- FROM mtl_serial_numbers_temp

6334: -- ELSIF p_serial_number_control_code IN (2,5,6) THEN
6335: -- BEGIN
6336: -- SELECT '1'
6337: -- INTO l_dummy
6338: -- FROM mtl_serial_numbers_temp
6339: -- WHERE product_code = 'RCV'
6340: -- AND product_transaction_id = p_rti_id
6341: -- AND ROWNUM < 2;
6342: -- EXCEPTION

Line 8426: FROM mtl_serial_numbers_temp

8422: -- GET the TOTAL SERIAL QTY
8423: l_progress := 'WMSINB-14439';
8424: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
8425: INTO l_total_serial_qty
8426: FROM mtl_serial_numbers_temp
8427: WHERE product_code = 'RCV'
8428: AND product_transaction_id = l_rti_rec.interface_transaction_id;
8429:
8430: IF (l_total_lot_qty = 0 AND l_total_serial_qty = 0) THEN

Line 8487: -- wms_lpn_contents and null out the lpn_id on mtl_serial_numbers

8483:
8484: -- We should not be doing full unpack. Instead if one of
8485: -- the conditions used to set l_full_unpack to true is
8486: -- met then we should null out the lot_number on
8487: -- wms_lpn_contents and null out the lpn_id on mtl_serial_numbers
8488:
8489: UPDATE wms_lpn_contents
8490: SET lot_number = NULL,
8491: revision = NULL

Line 8495: UPDATE mtl_serial_numbers

8491: revision = NULL
8492: WHERE parent_lpn_id = l_rti_rec.lpn_id
8493: AND inventory_item_id = l_rti_rec.item_id;
8494:
8495: UPDATE mtl_serial_numbers
8496: SET lpn_id = NULL
8497: WHERE inventory_item_id = l_rti_rec.item_id
8498: AND lpn_id = l_rti_rec.lpn_id;
8499:

Line 9121: update mtl_serial_numbers msn

9117: l_progress := 'WMSINB-14864';
9118: -- UPDATE SERIAL STATUS to 4 for serial control code at SO ISUUE CASE
9119: if l_serial_control_code = 6 then
9120: l_progress := 'WMSINB-14867';
9121: update mtl_serial_numbers msn
9122: set msn.current_status = 4
9123: where msn.inventory_item_id = l_rti_rec.item_id
9124: and msn.current_organization_id = l_rti_rec.to_organization_id
9125: and exists ( select 1

Line 9126: from mtl_serial_numbers_temp msnt

9122: set msn.current_status = 4
9123: where msn.inventory_item_id = l_rti_rec.item_id
9124: and msn.current_organization_id = l_rti_rec.to_organization_id
9125: and exists ( select 1
9126: from mtl_serial_numbers_temp msnt
9127: where msnt.product_code = 'RCV'
9128: and msnt.product_transaction_id = p_txn_id
9129: and msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number
9130: AND Length(msn.serial_number) = Length(msnt.fm_serial_number)

Line 10056: Insert into MTL_SERIAL_NUMBERS_INTERFACE

10052:
10053: l_user_id := fnd_global.user_id;
10054: l_login_id := fnd_global.login_id;
10055:
10056: Insert into MTL_SERIAL_NUMBERS_INTERFACE
10057: (
10058: transaction_interface_id,
10059: Source_Code,
10060: Source_Line_Id,

Line 11040: from mtl_serial_numbers msn

11036: l_serial_interface_id := null;
11037:
11038: -- Call insert MSNI for linked Serials Here
11039: For l_serial_rec in ( select msn.serial_number
11040: from mtl_serial_numbers msn
11041: where msn.lpn_id = p_lpn_id
11042: and msn.current_organization_id = p_org_id
11043: and msn.lot_number = l_lot_rec.lot_number
11044: and msn.inventory_item_id = p_item_id

Line 11104: from mtl_serial_numbers msn

11100: -- Cases for JUST SERIAL CONTROLLED
11101: if (l_serial_interface_inserted <> TRUE ) then
11102:
11103: For l_serial_rec in ( select msn.serial_number
11104: from mtl_serial_numbers msn
11105: where msn.lpn_id = p_lpn_id
11106: and msn.current_organization_id = p_org_id
11107: and msn.inventory_item_id = p_item_id
11108: )

Line 13154: from mtl_serial_numbers msn

13150: l_serial_disc := 1;
13151:
13152: For l_test_serial_rec in (
13153: select serial_number
13154: from mtl_serial_numbers msn
13155: WHERE msn.lpn_id = l_lpn_contents.lpn_id
13156: AND msn.inventory_item_id = l_lpn_contents.inventory_item_id
13157: )
13158: Loop

Line 13162: FROM mtl_serial_numbers_interface msni

13158: Loop
13159: BEGIN
13160: SELECT 1
13161: INTO l_serial_disc
13162: FROM mtl_serial_numbers_interface msni
13163: , rcv_transactions_interface rti
13164: where rti.lpn_group_id = p_lpn_group_id
13165: and (rti.lpn_id = l_lpn_contents.lpn_id
13166: OR rti.license_plate_number = l_lpn_contents.license_plate_number)

Line 16158: INSERT INTO mtl_serial_numbers_interface

16154: IF (l_debug = 1) THEN
16155: print_debug('insert_msni_rowid:010: Entry Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
16156: END If;
16157:
16158: INSERT INTO mtl_serial_numbers_interface
16159: (TRANSACTION_INTERFACE_ID,
16160: SOURCE_CODE,
16161: SOURCE_LINE_ID,
16162: LAST_UPDATE_DATE,

Line 16345: FROM mtl_serial_numbers_interface

16341: ATTRIBUTE14,
16342: ATTRIBUTE15,
16343: PRODUCT_CODE,
16344: p_product_txn_id
16345: FROM mtl_serial_numbers_interface
16346: WHERE ROWID = p_rowid);
16347:
16348: IF (l_debug = 1) THEN
16349: print_debug('insert_msni_rowid:020: Exit Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 16387: FROM mtl_serial_numbers_interface

16383: CURSOR msni_recs (l_old_rti_id NUMBER) IS
16384: SELECT fm_serial_number,
16385: to_serial_number,
16386: ROWID
16387: FROM mtl_serial_numbers_interface
16388: WHERE product_code = 'RCV'
16389: AND product_transaction_id = l_old_rti_id;
16390:
16391: l_msni_rec msni_recs%ROWTYPE;

Line 16397: FROM mtl_serial_numbers_interface

16393: CURSOR msni_recs_lotserial(l_serial_transaction_temp_id NUMBER) IS
16394: SELECT fm_serial_number,
16395: to_serial_number,
16396: ROWID
16397: FROM mtl_serial_numbers_interface
16398: WHERE transaction_interface_id = l_serial_transaction_temp_id;
16399:
16400: l_remaining_quantity NUMBER;
16401: l_primary_rem_qty NUMBER;

Line 16477: FROM mtl_serial_numbers_interface

16473:
16474: BEGIN
16475: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
16476: INTO l_total_serial_qty
16477: FROM mtl_serial_numbers_interface
16478: WHERE product_code = 'RCV'
16479: AND product_transaction_id = l_orig_interface_trx_id;
16480: EXCEPTION
16481: WHEN no_data_found THEN

Line 16583: FROM mtl_serial_numbers_interface msni

16579: mtli.transaction_quantity)
16580: )
16581: = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
16582: msni.to_serial_number))
16583: FROM mtl_serial_numbers_interface msni
16584: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id));
16585: EXCEPTION
16586: WHEN no_data_found then
16587: l_lot_ser_qty := 0;

Line 16697: FROM mtl_serial_numbers_interface

16693:
16694: BEGIN
16695: SELECT SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number))
16696: INTO l_total_serial_qty
16697: FROM mtl_serial_numbers_interface
16698: WHERE product_code = 'RCV'
16699: AND product_transaction_id = l_orig_interface_trx_id;
16700: EXCEPTION
16701: WHEN no_data_found THEN

Line 16754: FROM mtl_serial_numbers_interface msni

16750: get_primary_qty(l_to_organization_id,l_item_id,l_uom_code,
16751: mtli.transaction_quantity)
16752: ) = (SELECT SUM(inv_serial_number_pub.get_serial_diff(msni.fm_serial_number,
16753: msni.to_serial_number))
16754: FROM mtl_serial_numbers_interface msni
16755: WHERE msni.transaction_interface_id = mtli.serial_transaction_temp_id));
16756: EXCEPTION
16757: WHEN no_data_found then
16758: l_lot_ser_qty := 0;

Line 16895: UPDATE mtl_serial_numbers_interface

16891: IF (l_debug = 1) THEN
16892: print_debug('split_lot_serial:170: update msni ', 1);
16893: END If;
16894: -- update the msni with new rti id.
16895: UPDATE mtl_serial_numbers_interface
16896: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id
16897: WHERE ROWID = l_msni_rec.ROWID;
16898:
16899: END LOOP; -- fetch msni_recs_lotserial

Line 16983: UPDATE mtl_serial_numbers_interface

16979: IF (l_debug = 1) THEN
16980: print_debug('split_lot_serial:210: update msni ', 1);
16981: END If;
16982:
16983: UPDATE mtl_serial_numbers_interface
16984: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id,
16985: transaction_interface_id = l_new_serial_txn_temp_id
16986: WHERE ROWID = l_msni_rec.ROWID;
16987:

Line 17033: UPDATE mtl_serial_numbers_interface

17029: IF (l_debug = 1) THEN
17030: print_debug('split_lot_serial:230: update msni ', 1);
17031: END IF;
17032:
17033: UPDATE mtl_serial_numbers_interface
17034: SET fm_serial_number = l_new_from_ser_num
17035: WHERE ROWID = l_msni_rec.ROWID;
17036:
17037: l_remaining_serial_qty := 0;

Line 17086: UPDATE mtl_serial_numbers_interface

17082: print_debug('split_lot_serial:240: update msni ', 1);
17083: print_debug('split_lot_serial:241: new rti '||p_rti_tb(newrti).new_interface_trx_id, 1);
17084: END If;
17085:
17086: UPDATE mtl_serial_numbers_interface
17087: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id
17088: WHERE ROWID = l_msni_rec.ROWID;
17089:
17090: l_remaining_quantity := l_remaining_quantity -

Line 17139: UPDATE mtl_serial_numbers_interface

17135: IF (l_debug = 1) THEN
17136: print_debug('split_lot_serial:260: update msni ', 1);
17137: END If;
17138:
17139: UPDATE mtl_serial_numbers_interface
17140: SET fm_serial_number = l_new_from_ser_num
17141: WHERE ROWID = l_msni_rec.ROWID;
17142:
17143: l_remaining_quantity := 0;

Line 17266: UPDATE mtl_serial_numbers

17262: p_serial_number IN VARCHAR2)
17263: RETURN BOOLEAN
17264: IS
17265: BEGIN
17266: UPDATE mtl_serial_numbers
17267: SET group_mark_id = -7937
17268: WHERE inventory_item_id = p_item_id
17269: AND serial_number = p_serial_number;
17270:

Line 17539: INSERT INTO mtl_serial_numbers_temp (TRANSACTION_TEMP_ID,

17535:
17536:
17537:
17538:
17539: INSERT INTO mtl_serial_numbers_temp (TRANSACTION_TEMP_ID,
17540: LAST_UPDATE_DATE,
17541: LAST_UPDATED_BY,
17542: CREATION_DATE,
17543: CREATED_BY,

Line 17717: FROM mtl_serial_numbers_interface

17713: CYCLES_SINCE_MARK,
17714: NUMBER_OF_REPAIRS,
17715: PRODUCT_CODE,
17716: product_transaction_id
17717: FROM mtl_serial_numbers_interface
17718: WHERE product_code = 'RCV'
17719: AND product_transaction_id = p_rti_id;
17720:
17721: IF (l_debug = 1) THEN

Line 17731: DELETE FROM mtl_serial_numbers_interface

17727: DELETE FROM mtl_transaction_lots_interface
17728: WHERE product_code = 'RCV'
17729: AND product_transaction_id = p_rti_id;
17730:
17731: DELETE FROM mtl_serial_numbers_interface
17732: WHERE product_code = 'RCV'
17733: AND product_transaction_id = p_rti_id;
17734:
17735: EXCEPTION

Line 17923: FROM MTL_SERIAL_NUMBERS_TEMP

17919: , n_attribute10
17920: , status_id
17921: , territory_code
17922: , ROWID
17923: FROM MTL_SERIAL_NUMBERS_TEMP
17924: WHERE PRODUCT_CODE = 'RCV'
17925: AND PRODUCT_TRANSACTION_ID = L_RTI_ID;
17926:
17927: L_MSNT_REC C_MSNT%ROWTYPE;

Line 17979: FROM MTL_SERIAL_NUMBERS_TEMP

17975: , n_attribute10
17976: , status_id
17977: , territory_code
17978: , ROWID
17979: FROM MTL_SERIAL_NUMBERS_TEMP
17980: WHERE PRODUCT_CODE = 'RCV'
17981: AND transaction_temp_id = L_SERIAL_TXN_ID;
17982:
17983: l_rti_id NUMBER;

Line 18375: FROM mtl_serial_numbers_temp

18371: SELECT '1'
18372: INTO l_dummy
18373: FROM dual
18374: WHERE exists (SELECT 1
18375: FROM mtl_serial_numbers_temp
18376: WHERE product_code = 'RCV'
18377: AND product_transaction_id = l_rti_id);
18378:
18379: --Fail transaction

Line 19379: FROM MTL_SERIAL_NUMBERS

19375: , l_curr_lot_num
19376: , l_curr_lpn_id
19377: , l_inspection_status
19378: , l_group_mark_id
19379: FROM MTL_SERIAL_NUMBERS
19380: WHERE SERIAL_NUMBER = l_serial_number
19381: AND inventory_item_id = l_item_id;
19382:
19383: l_serial_exists := 1;

Line 19986: FROM mtl_serial_numbers

19982: SELECT '1'
19983: INTO l_dummy
19984: FROM dual
19985: WHERE exists (SELECT '1'
19986: FROM mtl_serial_numbers
19987: WHERE inventory_item_id = l_item_id
19988: AND current_organization_id = l_org_id
19989: AND current_status IN (1, 4) --Do we need 4 here
19990: AND serial_number = l_serial_number

Line 20441: FROM MTL_SERIAL_NUMBERS

20437: , l_curr_lpn_id
20438: , l_inspection_status
20439: , l_group_mark_id
20440: , l_last_transaction_id --bug 5168883
20441: FROM MTL_SERIAL_NUMBERS
20442: WHERE SERIAL_NUMBER = l_serial_number
20443: AND inventory_item_id = l_item_id;
20444:
20445: l_serial_exists := 1;

Line 20636: update mtl_serial_numbers msn

20632: --update the serial row
20633: IF (l_debug = 1) THEN
20634: print_debug('VALIDATE_LOT_SERIAL_INFO: UPDATING LOT_NUMBER to null as destination org is not lot controlled', 1);
20635: END IF;
20636: update mtl_serial_numbers msn
20637: set lot_number = null
20638: where msn.serial_number = l_serial_number
20639: AND inventory_item_id = l_item_id;
20640: end if;

Line 21059: FROM mtl_serial_numbers

21055: SELECT '1'
21056: INTO l_dummy
21057: FROM dual
21058: WHERE exists (SELECT '1'
21059: FROM mtl_serial_numbers
21060: WHERE inventory_item_id = l_item_id
21061: AND current_organization_id = l_org_id
21062: AND current_status IN (1, 4) --Do we need 4 here
21063: AND serial_number = l_serial_number

Line 22050: FROM MTL_SERIAL_NUMBERS

22046: , l_curr_lot_num
22047: , l_curr_lpn_id
22048: , l_inspection_status
22049: , l_group_mark_id
22050: FROM MTL_SERIAL_NUMBERS
22051: WHERE SERIAL_NUMBER = l_serial_number
22052: AND inventory_item_id = l_item_id;
22053:
22054: l_serial_exists := 1;

Line 22477: FROM MTL_SERIAL_NUMBERS

22473: , l_curr_lot_num
22474: , l_curr_lpn_id
22475: , l_inspection_status
22476: , l_group_mark_id
22477: FROM MTL_SERIAL_NUMBERS
22478: WHERE SERIAL_NUMBER = l_serial_number
22479: AND inventory_item_id = l_item_id;
22480:
22481: l_serial_exists := 1;

Line 24444: FROM MTL_SERIAL_NUMBERS

24440: , l_curr_lot_num
24441: , l_curr_lpn_id
24442: , l_inspection_status
24443: , l_group_mark_id
24444: FROM MTL_SERIAL_NUMBERS
24445: WHERE SERIAL_NUMBER = l_serial_number
24446: AND inventory_item_id = l_item_id;
24447:
24448: l_serial_exists := 1;

Line 25211: FROM MTL_SERIAL_NUMBERS

25207: , l_curr_lot_num
25208: , l_curr_lpn_id
25209: , l_inspection_status
25210: , l_group_mark_id
25211: FROM MTL_SERIAL_NUMBERS
25212: WHERE SERIAL_NUMBER = l_serial_number
25213: AND inventory_item_id = l_item_id;
25214:
25215: l_serial_exists := 1;

Line 26808: FROM MTL_SERIAL_NUMBERS

26804: , l_curr_lot_num
26805: , l_curr_lpn_id
26806: , l_inspection_status
26807: , l_group_mark_id
26808: FROM MTL_SERIAL_NUMBERS
26809: WHERE SERIAL_NUMBER = l_serial_number
26810: AND inventory_item_id = l_item_id;
26811:
26812: l_serial_exists := 1;

Line 27728: FROM MTL_SERIAL_NUMBERS

27724: , l_curr_lot_num
27725: , l_curr_lpn_id
27726: , l_inspection_status
27727: , l_group_mark_id
27728: FROM MTL_SERIAL_NUMBERS
27729: WHERE SERIAL_NUMBER = l_serial_number
27730: AND inventory_item_id = l_item_id;
27731:
27732: l_serial_exists := 1;