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.WMS_PICK_DROP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1684: FROM mtl_serial_numbers_temp msnt

1680: CURSOR c_srl_lot_details
1681: ( p_temp_id IN NUMBER
1682: ) IS
1683: SELECT msnt.fm_serial_number
1684: FROM mtl_serial_numbers_temp msnt
1685: WHERE msnt.transaction_temp_id = p_temp_id;
1686:
1687:
1688: CURSOR c_srl_numbers

Line 1692: FROM mtl_serial_numbers_temp msnt

1688: CURSOR c_srl_numbers
1689: ( p_temp_id IN NUMBER
1690: ) IS
1691: SELECT msnt.fm_serial_number
1692: FROM mtl_serial_numbers_temp msnt
1693: WHERE msnt.transaction_temp_id = p_temp_id;
1694:
1695: BEGIN
1696: x_return_status := fnd_api.g_ret_sts_success;

Line 4758: FROM mtl_serial_numbers_temp

4754: ( p_parent_id IN NUMBER
4755: ) IS
4756: SELECT rowid
4757: , fm_serial_number
4758: FROM mtl_serial_numbers_temp
4759: WHERE transaction_temp_id = p_parent_id;
4760:
4761: msnt_rec c_get_msnt%ROWTYPE;
4762:

Line 4771: , mtl_serial_numbers_temp msnt

4767: ) IS
4768: SELECT msnt.rowid
4769: , msnt.fm_serial_number
4770: FROM mtl_transaction_lots_temp mtlt
4771: , mtl_serial_numbers_temp msnt
4772: WHERE mtlt.transaction_temp_id = p_parent_id
4773: AND mtlt.lot_number = p_lot_num
4774: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
4775:

Line 4877: UPDATE mtl_serial_numbers_temp msnt

4873: AND
4874: (l_srl_qty > 0)
4875: )
4876: LOOP
4877: UPDATE mtl_serial_numbers_temp msnt
4878: SET transaction_temp_id = p_temp_id
4879: WHERE rowid = msnt_rec.rowid;
4880:
4881: l_srl_qty := l_srl_qty - 1;

Line 4891: UPDATE mtl_serial_numbers

4887: , l_api_name
4888: );
4889: END IF;
4890:
4891: UPDATE mtl_serial_numbers
4892: SET group_mark_id = p_txn_header_id
4893: WHERE current_organization_id = mmtt_info_rec.organization_id
4894: AND inventory_item_id = mmtt_info_rec.inventory_item_id
4895: AND NVL(revision,'@@@@') = NVL(mmtt_info_rec.revision,'@@@@')

Line 4980: UPDATE mtl_serial_numbers_temp msnt

4976: AND
4977: (l_srl_qty > 0)
4978: )
4979: LOOP
4980: UPDATE mtl_serial_numbers_temp msnt
4981: SET transaction_temp_id = l_serial_temp_id
4982: WHERE rowid = lot_msnt_rec.rowid;
4983:
4984: l_srl_qty := l_srl_qty - 1;

Line 4994: UPDATE mtl_serial_numbers

4990: , l_api_name
4991: );
4992: END IF;
4993:
4994: UPDATE mtl_serial_numbers
4995: SET group_mark_id = p_txn_header_id
4996: WHERE current_organization_id = mmtt_info_rec.organization_id
4997: AND inventory_item_id = mmtt_info_rec.inventory_item_id
4998: AND NVL(revision,'@@@@') = NVL(mmtt_info_rec.revision,'@@@@')

Line 6304: , mtl_serial_numbers_temp msnt

6300: ) IS
6301: SELECT msnt.rowid
6302: , mmtt.transaction_temp_id
6303: FROM mtl_material_transactions_temp mmtt
6304: , mtl_serial_numbers_temp msnt
6305: WHERE mmtt.organization_id = p_org_id
6306: AND mmtt.transfer_lpn_id = p_xfer_lpn_id
6307: AND mmtt.transaction_temp_id = mmtt.parent_line_id
6308: AND ( mmtt.content_lpn_id IS NULL

Line 6326: , mtl_serial_numbers_temp msnt

6322: ) IS
6323: SELECT msnt.rowid
6324: , mmtt.transaction_temp_id
6325: FROM mtl_material_transactions_temp mmtt
6326: , mtl_serial_numbers_temp msnt
6327: WHERE mmtt.organization_id = p_org_id
6328: AND mmtt.transfer_lpn_id = p_xfer_lpn_id
6329: AND mmtt.transaction_temp_id = mmtt.parent_line_id
6330: AND mmtt.content_lpn_id = p_lpn_id

Line 6346: , mtl_serial_numbers_temp msnt

6342: SELECT msnt.rowid
6343: , mmtt.transaction_temp_id transaction_temp_id
6344: FROM mtl_material_transactions_temp mmtt
6345: , mtl_transaction_lots_temp mtlt
6346: , mtl_serial_numbers_temp msnt
6347: WHERE mmtt.organization_id = p_org_id
6348: AND mmtt.transfer_lpn_id = p_xfer_lpn_id
6349: AND mmtt.transaction_temp_id = mmtt.parent_line_id
6350: AND NVL(mmtt.content_lpn_id,0) = NVL(p_lpn_id,0)

Line 6388: , mtl_serial_numbers_temp msnt

6384: SELECT mtlt.primary_quantity
6385: , COUNT(msnt.fm_serial_number) srl_count
6386: FROM mtl_material_transactions_temp mmtt
6387: , mtl_transaction_lots_temp mtlt
6388: , mtl_serial_numbers_temp msnt
6389: WHERE mmtt.transaction_temp_id = p_temp_id
6390: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
6391: AND mtlt.lot_number = p_lot_num
6392: AND msnt.transaction_temp_id (+) = mtlt.serial_transaction_temp_id

Line 6402: , mtl_serial_numbers_temp msnt

6398: ) IS
6399: SELECT mmtt.primary_quantity
6400: , COUNT(msnt.fm_serial_number) srl_count
6401: FROM mtl_material_transactions_temp mmtt
6402: , mtl_serial_numbers_temp msnt
6403: WHERE mmtt.transaction_temp_id = p_temp_id
6404: AND msnt.transaction_temp_id (+) = mmtt.transaction_temp_id
6405: GROUP BY mmtt.primary_quantity;
6406:

Line 7122: UPDATE mtl_serial_numbers_temp msnt

7118: WHERE mtlt.transaction_temp_id = l_transaction_temp_id
7119: AND mtlt.lot_number = p_lot_number;
7120: END IF;
7121:
7122: UPDATE mtl_serial_numbers_temp msnt
7123: SET transaction_temp_id = l_srl_temp_id
7124: WHERE rowid = lot_msnt_rec.rowid;
7125:
7126: ELSE

Line 7127: UPDATE mtl_serial_numbers_temp msnt

7123: SET transaction_temp_id = l_srl_temp_id
7124: WHERE rowid = lot_msnt_rec.rowid;
7125:
7126: ELSE
7127: UPDATE mtl_serial_numbers_temp msnt
7128: SET transaction_temp_id = l_transaction_temp_id
7129: WHERE rowid = msnt_rec.rowid;
7130:
7131: END IF;

Line 7203: UPDATE mtl_serial_numbers

7199: END IF;
7200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7201: END;
7202:
7203: UPDATE mtl_serial_numbers
7204: SET group_mark_id = l_txn_header_id
7205: WHERE current_organization_id = p_organization_id
7206: AND inventory_item_id = p_item_id
7207: AND NVL(revision,'@@@@') = NVL(p_revision,'@@@@')