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_TEMP

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

143:
144: dbms_sql.close_cursor(l_epc_cursor);
145: ELSE --Serial
146: l_epc_sql := 'SELECT ' || l_epc_column;
147: l_epc_sql := l_epc_sql || ' FROM mtl_serial_numbers_temp';
148: l_epc_sql := l_epc_sql || ' WHERE rowid = :row_id';
149:
150: IF (l_debug = 1) THEN
151: print_debug('l_epc_sql: '||l_epc_sql,4);

Line 609: mtl_serial_numbers_temp msnt

605: ,msnt.time_since_mark time_since_mark
606: ,msnt.cycles_since_mark cycles_since_mark
607: ,msnt.number_of_repairs number_of_repairs
608: from
609: mtl_serial_numbers_temp msnt
610: ,rcv_transactions_interface rti
611: where
612: msnt.product_code = 'RCV'
613: AND msnt.product_transaction_id = p_prod_txn_tmp_id

Line 1081: DELETE FROM mtl_serial_numbers_temp

1077: AND product_transaction_id = p_prod_txn_tmp_id;
1078:
1079: l_progress := 'WMSINB-10883';
1080:
1081: DELETE FROM mtl_serial_numbers_temp
1082: WHERE product_code = 'RCV'
1083: AND product_transaction_id = p_prod_txn_tmp_id;
1084:
1085: IF (l_debug = 1) THEN

Line 1769: FROM mtl_serial_numbers_temp

1765: BEGIN
1766: l_progress := 'WMSINB-11324';
1767: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
1768: INTO l_total_ser_qty
1769: FROM mtl_serial_numbers_temp
1770: WHERE product_code = p_product_code
1771: AND product_transaction_id = p_product_txn_id;
1772: END;
1773: End if;

Line 1797: from mtl_serial_numbers_temp msnt

1793: l_progress := 'WMSINB-11351';
1794: For l_serial_rec in ( select fm_serial_number
1795: , to_serial_number
1796: , inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1797: from mtl_serial_numbers_temp msnt
1798: where msnt.transaction_temp_id = l_lot_rec.serial_transaction_temp_id
1799: and msnt.product_transaction_id = p_product_txn_id
1800: and msnt.product_code = 'RCV'
1801: )

Line 1916: from mtl_serial_numbers_temp msnt

1912: l_progress := 'WMSINB-11453';
1913: For l_serial_rec in ( select fm_serial_number
1914: ,to_serial_number
1915: ,inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number) serial_quantity
1916: from mtl_serial_numbers_temp msnt
1917: where msnt.product_transaction_id = p_product_txn_id
1918: and msnt.product_code = 'RCV'
1919: )
1920: Loop

Line 3273: from mtl_serial_numbers_temp

3269:
3270: --BUG 5008139 -- Getting the count of serial records in MSNT
3271: select count(*)
3272: into l_count
3273: from mtl_serial_numbers_temp
3274: where product_code = 'RCV'
3275: and product_transaction_id = p_product_txn_id;
3276:
3277: IF (l_debug = 1) THEN

Line 3357: , mtl_serial_numbers_temp msnt

3353: -- BUG 5611567
3354: msn.ROWID in (
3355: select msn1.ROWID
3356: from mtl_serial_numbers msn1
3357: , mtl_serial_numbers_temp msnt
3358: where msn1.inventory_item_id = p_item_id
3359: and msnt.product_code = 'RCV'
3360: and msnt.product_transaction_id = p_product_txn_id
3361: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 3378: -- from mtl_serial_numbers_temp msnt

3374: -- lot_line_mark_id = NULL
3375: -- where msn.inventory_item_id = p_item_id
3376: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3377: -- and exists ( select 1
3378: -- from mtl_serial_numbers_temp msnt
3379: -- where msnt.product_code = 'RCV'
3380: -- and msnt.product_transaction_id = p_product_txn_id
3381: -- and msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number
3382: -- AND Length(msn.serial_number) = Length(msnt.fm_serial_number)

Line 3393: -- from mtl_serial_numbers_temp msnt

3389: -- group_mark_id = NULL
3390: -- where msn.inventory_item_id = p_item_id
3391: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3392: -- and exists ( select 1
3393: -- from mtl_serial_numbers_temp msnt
3394: -- where msnt.product_code = 'RCV'
3395: -- and msnt.product_transaction_id = p_product_txn_id
3396: -- and msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number
3397: -- AND Length(msn.serial_number) = Length(msnt.fm_serial_number)

Line 3420: -- mtl_serial_numbers_temp msnt

3416: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3417: -- -- BUG 5611567
3418: -- msn.ROWID in ( select msn1.ROWID
3419: -- from mtl_serial_numbers msn1 ,
3420: -- mtl_serial_numbers_temp msnt
3421: -- where msn1.inventory_item_id = p_item_id
3422: -- and msnt.product_code = 'RCV'
3423: -- and msnt.product_transaction_id = p_product_txn_id
3424: -- and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 3443: -- mtl_serial_numbers_temp msnt

3439: -- -- and msn.current_organization_id = p_organization_id -- this part is not needed as this was causing INTSHIP RECEIVE to fail
3440: -- -- BUG 5611567
3441: -- msn.ROWID in ( select msn1.ROWID
3442: -- from mtl_serial_numbers msn1 ,
3443: -- mtl_serial_numbers_temp msnt
3444: -- where msn1.inventory_item_id = p_item_id
3445: -- and msnt.product_code = 'RCV'
3446: -- and msnt.product_transaction_id = p_product_txn_id
3447: -- and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 5301: -- FROM mtl_serial_numbers_temp

5297: -- ELSIF p_serial_number_control_code IN (2,5,6) THEN
5298: -- BEGIN
5299: -- SELECT '1'
5300: -- INTO l_dummy
5301: -- FROM mtl_serial_numbers_temp
5302: -- WHERE product_code = 'RCV'
5303: -- AND product_transaction_id = p_rti_id
5304: -- AND ROWNUM < 2;
5305: -- EXCEPTION

Line 6510: -- FROM mtl_serial_numbers_temp

6506: -- ELSIF p_serial_number_control_code IN (2,5,6) THEN
6507: -- BEGIN
6508: -- SELECT '1'
6509: -- INTO l_dummy
6510: -- FROM mtl_serial_numbers_temp
6511: -- WHERE product_code = 'RCV'
6512: -- AND product_transaction_id = p_rti_id
6513: -- AND ROWNUM < 2;
6514: -- EXCEPTION

Line 8810: FROM mtl_serial_numbers_temp

8806: -- GET the TOTAL SERIAL QTY
8807: l_progress := 'WMSINB-14439';
8808: SELECT Nvl(SUM(inv_serial_number_pub.get_serial_diff(fm_serial_number,to_serial_number)),0)
8809: INTO l_total_serial_qty
8810: FROM mtl_serial_numbers_temp
8811: WHERE product_code = 'RCV'
8812: AND product_transaction_id = l_rti_rec.interface_transaction_id;
8813:
8814: IF (l_total_lot_qty = 0 AND l_total_serial_qty = 0) THEN

Line 9544: from mtl_serial_numbers_temp msnt

9540: set msn.current_status = 4
9541: where msn.inventory_item_id = l_rti_rec.item_id
9542: and msn.current_organization_id = l_rti_rec.to_organization_id
9543: and exists ( select 1
9544: from mtl_serial_numbers_temp msnt
9545: where msnt.product_code = 'RCV'
9546: and msnt.product_transaction_id = p_txn_id
9547: and msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number
9548: AND Length(msn.serial_number) = Length(msnt.fm_serial_number)

Line 18501: INSERT INTO mtl_serial_numbers_temp (TRANSACTION_TEMP_ID,

18497: END;
18498:
18499: IF (x_serial_number_control_code <> 1) THEN */ -- Bug 13886318 need to revert bug 12329840
18500:
18501: INSERT INTO mtl_serial_numbers_temp (TRANSACTION_TEMP_ID,
18502: LAST_UPDATE_DATE,
18503: LAST_UPDATED_BY,
18504: CREATION_DATE,
18505: CREATED_BY,

Line 18916: FROM MTL_SERIAL_NUMBERS_TEMP

18912: , attribute13
18913: , attribute14
18914: , attribute15
18915: , ROWID
18916: FROM MTL_SERIAL_NUMBERS_TEMP
18917: WHERE PRODUCT_CODE = 'RCV'
18918: AND PRODUCT_TRANSACTION_ID = L_RTI_ID;
18919:
18920: L_MSNT_REC C_MSNT%ROWTYPE;

Line 18988: FROM MTL_SERIAL_NUMBERS_TEMP

18984: , attribute13
18985: , attribute14
18986: , attribute15
18987: , ROWID
18988: FROM MTL_SERIAL_NUMBERS_TEMP
18989: WHERE PRODUCT_CODE = 'RCV'
18990: AND transaction_temp_id = L_SERIAL_TXN_ID;
18991:
18992: l_rti_id NUMBER;

Line 19422: FROM mtl_serial_numbers_temp

19418: SELECT '1'
19419: INTO l_dummy
19420: FROM dual
19421: WHERE exists (SELECT 1
19422: FROM mtl_serial_numbers_temp
19423: WHERE product_code = 'RCV'
19424: AND product_transaction_id = l_rti_id);
19425:
19426: --Fail transaction