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 1543: FROM mtl_serial_numbers_temp msnt

1539: CURSOR c_srl_lot_details
1540: ( p_temp_id IN NUMBER
1541: ) IS
1542: SELECT msnt.fm_serial_number
1543: FROM mtl_serial_numbers_temp msnt
1544: WHERE msnt.transaction_temp_id = p_temp_id;
1545:
1546:
1547: CURSOR c_srl_numbers

Line 1551: FROM mtl_serial_numbers_temp msnt

1547: CURSOR c_srl_numbers
1548: ( p_temp_id IN NUMBER
1549: ) IS
1550: SELECT msnt.fm_serial_number
1551: FROM mtl_serial_numbers_temp msnt
1552: WHERE msnt.transaction_temp_id = p_temp_id;
1553:
1554: BEGIN
1555: x_return_status := fnd_api.g_ret_sts_success;

Line 4480: FROM mtl_serial_numbers_temp

4476: ( p_parent_id IN NUMBER
4477: ) IS
4478: SELECT rowid
4479: , fm_serial_number
4480: FROM mtl_serial_numbers_temp
4481: WHERE transaction_temp_id = p_parent_id;
4482:
4483: msnt_rec c_get_msnt%ROWTYPE;
4484:

Line 4493: , mtl_serial_numbers_temp msnt

4489: ) IS
4490: SELECT msnt.rowid
4491: , msnt.fm_serial_number
4492: FROM mtl_transaction_lots_temp mtlt
4493: , mtl_serial_numbers_temp msnt
4494: WHERE mtlt.transaction_temp_id = p_parent_id
4495: AND mtlt.lot_number = p_lot_num
4496: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
4497:

Line 4599: UPDATE mtl_serial_numbers_temp msnt

4595: AND
4596: (l_srl_qty > 0)
4597: )
4598: LOOP
4599: UPDATE mtl_serial_numbers_temp msnt
4600: SET transaction_temp_id = p_temp_id
4601: WHERE rowid = msnt_rec.rowid;
4602:
4603: l_srl_qty := l_srl_qty - 1;

Line 4613: UPDATE mtl_serial_numbers

4609: , l_api_name
4610: );
4611: END IF;
4612:
4613: UPDATE mtl_serial_numbers
4614: SET group_mark_id = p_txn_header_id
4615: WHERE current_organization_id = mmtt_info_rec.organization_id
4616: AND inventory_item_id = mmtt_info_rec.inventory_item_id
4617: AND NVL(revision,'@@@@') = NVL(mmtt_info_rec.revision,'@@@@')

Line 4702: UPDATE mtl_serial_numbers_temp msnt

4698: AND
4699: (l_srl_qty > 0)
4700: )
4701: LOOP
4702: UPDATE mtl_serial_numbers_temp msnt
4703: SET transaction_temp_id = l_serial_temp_id
4704: WHERE rowid = lot_msnt_rec.rowid;
4705:
4706: l_srl_qty := l_srl_qty - 1;

Line 4716: UPDATE mtl_serial_numbers

4712: , l_api_name
4713: );
4714: END IF;
4715:
4716: UPDATE mtl_serial_numbers
4717: SET group_mark_id = p_txn_header_id
4718: WHERE current_organization_id = mmtt_info_rec.organization_id
4719: AND inventory_item_id = mmtt_info_rec.inventory_item_id
4720: AND NVL(revision,'@@@@') = NVL(mmtt_info_rec.revision,'@@@@')

Line 6026: , mtl_serial_numbers_temp msnt

6022: ) IS
6023: SELECT msnt.rowid
6024: , mmtt.transaction_temp_id
6025: FROM mtl_material_transactions_temp mmtt
6026: , mtl_serial_numbers_temp msnt
6027: WHERE mmtt.organization_id = p_org_id
6028: AND mmtt.transfer_lpn_id = p_xfer_lpn_id
6029: AND mmtt.transaction_temp_id = mmtt.parent_line_id
6030: AND ( mmtt.content_lpn_id IS NULL

Line 6048: , mtl_serial_numbers_temp msnt

6044: ) IS
6045: SELECT msnt.rowid
6046: , mmtt.transaction_temp_id
6047: FROM mtl_material_transactions_temp mmtt
6048: , mtl_serial_numbers_temp msnt
6049: WHERE mmtt.organization_id = p_org_id
6050: AND mmtt.transfer_lpn_id = p_xfer_lpn_id
6051: AND mmtt.transaction_temp_id = mmtt.parent_line_id
6052: AND mmtt.content_lpn_id = p_lpn_id

Line 6068: , mtl_serial_numbers_temp msnt

6064: SELECT msnt.rowid
6065: , mmtt.transaction_temp_id transaction_temp_id
6066: FROM mtl_material_transactions_temp mmtt
6067: , mtl_transaction_lots_temp mtlt
6068: , mtl_serial_numbers_temp msnt
6069: WHERE mmtt.organization_id = p_org_id
6070: AND mmtt.transfer_lpn_id = p_xfer_lpn_id
6071: AND mmtt.transaction_temp_id = mmtt.parent_line_id
6072: AND NVL(mmtt.content_lpn_id,0) = NVL(p_lpn_id,0)

Line 6110: , mtl_serial_numbers_temp msnt

6106: SELECT mtlt.primary_quantity
6107: , COUNT(msnt.fm_serial_number) srl_count
6108: FROM mtl_material_transactions_temp mmtt
6109: , mtl_transaction_lots_temp mtlt
6110: , mtl_serial_numbers_temp msnt
6111: WHERE mmtt.transaction_temp_id = p_temp_id
6112: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id
6113: AND mtlt.lot_number = p_lot_num
6114: AND msnt.transaction_temp_id (+) = mtlt.serial_transaction_temp_id

Line 6124: , mtl_serial_numbers_temp msnt

6120: ) IS
6121: SELECT mmtt.primary_quantity
6122: , COUNT(msnt.fm_serial_number) srl_count
6123: FROM mtl_material_transactions_temp mmtt
6124: , mtl_serial_numbers_temp msnt
6125: WHERE mmtt.transaction_temp_id = p_temp_id
6126: AND msnt.transaction_temp_id (+) = mmtt.transaction_temp_id
6127: GROUP BY mmtt.primary_quantity;
6128:

Line 6844: UPDATE mtl_serial_numbers_temp msnt

6840: WHERE mtlt.transaction_temp_id = l_transaction_temp_id
6841: AND mtlt.lot_number = p_lot_number;
6842: END IF;
6843:
6844: UPDATE mtl_serial_numbers_temp msnt
6845: SET transaction_temp_id = l_srl_temp_id
6846: WHERE rowid = lot_msnt_rec.rowid;
6847:
6848: ELSE

Line 6849: UPDATE mtl_serial_numbers_temp msnt

6845: SET transaction_temp_id = l_srl_temp_id
6846: WHERE rowid = lot_msnt_rec.rowid;
6847:
6848: ELSE
6849: UPDATE mtl_serial_numbers_temp msnt
6850: SET transaction_temp_id = l_transaction_temp_id
6851: WHERE rowid = msnt_rec.rowid;
6852:
6853: END IF;

Line 6925: UPDATE mtl_serial_numbers

6921: END IF;
6922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6923: END;
6924:
6925: UPDATE mtl_serial_numbers
6926: SET group_mark_id = l_txn_header_id
6927: WHERE current_organization_id = p_organization_id
6928: AND inventory_item_id = p_item_id
6929: AND NVL(revision,'@@@@') = NVL(p_revision,'@@@@')