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 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 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 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 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 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 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 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 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 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 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 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