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_TRANSACTION_LOTS_TEMP

Line 1674: FROM mtl_transaction_lots_temp mtlt

1670: ) IS
1671: SELECT mtlt.lot_number
1672: , mtlt.primary_quantity
1673: , mtlt.serial_transaction_temp_id
1674: FROM mtl_transaction_lots_temp mtlt
1675: WHERE mtlt.transaction_temp_id = p_temp_id;
1676:
1677: c_lot_dtl_rec c_lot_details%ROWTYPE;
1678:

Line 3265: FROM mtl_transaction_lots_temp mtlt

3261: CURSOR c_get_lot_count
3262: ( p_temp_id IN NUMBER
3263: ) IS
3264: SELECT COUNT(*)
3265: FROM mtl_transaction_lots_temp mtlt
3266: WHERE mtlt.transaction_temp_id = p_temp_id;
3267:
3268:
3269: CURSOR c_get_lot_details

Line 3276: FROM mtl_transaction_lots_temp mtlt

3272: SELECT mtlt.rowid
3273: , mtlt.lot_number
3274: , mtlt.transaction_quantity
3275: , mtlt.primary_quantity
3276: FROM mtl_transaction_lots_temp mtlt
3277: WHERE mtlt.transaction_temp_id = p_temp_id;
3278:
3279: lot_dtl_rec c_get_lot_details%ROWTYPE;
3280:

Line 3408: UPDATE mtl_transaction_lots_temp

3404: , l_api_name
3405: );
3406: END IF;
3407:
3408: UPDATE mtl_transaction_lots_temp
3409: SET transaction_temp_id = l_transaction_temp_id
3410: WHERE rowid = lot_dtl_rec.rowid;
3411:
3412: IF l_debug = 1 THEN

Line 4770: FROM mtl_transaction_lots_temp mtlt

4766: , p_lot_num IN VARCHAR2
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;

Line 4785: FROM mtl_transaction_lots_temp mtlt

4781: ) IS
4782: SELECT mtlt.rowid
4783: , mtlt.lot_number
4784: , mtlt.primary_quantity
4785: FROM mtl_transaction_lots_temp mtlt
4786: WHERE mtlt.transaction_temp_id = p_tmp_id;
4787:
4788: lot_details_rec c_get_lot_records%ROWTYPE;
4789:

Line 4825: FROM mtl_transaction_lots_temp mtlt

4821: INTO l_dummy
4822: FROM dual
4823: WHERE EXISTS
4824: ( SELECT 'x'
4825: FROM mtl_transaction_lots_temp mtlt
4826: WHERE mtlt.transaction_temp_id = p_temp_id
4827: );
4828:
4829: IF l_debug = 1 THEN

Line 4971: UPDATE mtl_transaction_lots_temp

4967: , l_api_name
4968: );
4969: END IF;
4970:
4971: UPDATE mtl_transaction_lots_temp
4972: SET serial_transaction_temp_id = l_serial_temp_id
4973: WHERE rowid = lot_details_rec.rowid;
4974:
4975: WHILE ( (c_get_lot_msnt%FOUND)

Line 6271: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

6267: l_temp_id NUMBER;
6268: l_temp_found BOOLEAN;
6269:
6270: l_old_mtlt_rowid ROWID;
6271: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
6272:
6273: ii NUMBER;
6274: jj NUMBER;
6275:

Line 6345: , mtl_transaction_lots_temp mtlt

6341: ) IS
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

Line 6387: , mtl_transaction_lots_temp mtlt

6383: ) IS
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

Line 6694: FROM mtl_transaction_lots_temp mtlt

6690: THEN
6691: BEGIN
6692: SELECT mtlt.rowid
6693: INTO l_old_mtlt_rowid
6694: FROM mtl_transaction_lots_temp mtlt
6695: WHERE mtlt.transaction_temp_id = l_orig_temp_id
6696: AND mtlt.lot_number = p_lot_number
6697: AND rownum < 2;
6698:

Line 6703: UPDATE mtl_transaction_lots_temp

6699: IF l_debug = 1 THEN
6700: print_debug ('Found rowid for old MTLT record', l_api_name);
6701: END IF;
6702:
6703: UPDATE mtl_transaction_lots_temp
6704: SET transaction_quantity = transaction_quantity - 1
6705: , primary_quantity = primary_quantity - 1
6706: WHERE rowid = l_old_mtlt_rowid;
6707:

Line 6753: FROM mtl_transaction_lots_temp

6749: END IF;
6750:
6751: SELECT *
6752: INTO l_mtlt_rec
6753: FROM mtl_transaction_lots_temp
6754: WHERE rowid = l_old_mtlt_rowid;
6755:
6756: INSERT INTO mtl_transaction_lots_temp
6757: ( TRANSACTION_TEMP_ID

Line 6756: INSERT INTO mtl_transaction_lots_temp

6752: INTO l_mtlt_rec
6753: FROM mtl_transaction_lots_temp
6754: WHERE rowid = l_old_mtlt_rowid;
6755:
6756: INSERT INTO mtl_transaction_lots_temp
6757: ( TRANSACTION_TEMP_ID
6758: , LAST_UPDATE_DATE
6759: , LAST_UPDATED_BY
6760: , CREATION_DATE

Line 7079: FROM mtl_transaction_lots_temp mtlt

7075: --
7076: BEGIN
7077: SELECT mtlt.serial_transaction_temp_id
7078: INTO l_srl_temp_id
7079: FROM mtl_transaction_lots_temp mtlt
7080: WHERE mtlt.transaction_temp_id = l_transaction_temp_id
7081: AND mtlt.lot_number = p_lot_number;
7082:
7083: IF l_debug = 1 THEN

Line 7116: UPDATE mtl_transaction_lots_temp mtlt

7112: , l_api_name
7113: );
7114: END IF;
7115:
7116: UPDATE mtl_transaction_lots_temp mtlt
7117: SET mtlt.serial_transaction_temp_id = l_srl_temp_id
7118: WHERE mtlt.transaction_temp_id = l_transaction_temp_id
7119: AND mtlt.lot_number = p_lot_number;
7120: END IF;

Line 7161: UPDATE mtl_transaction_lots_temp

7157: END IF;
7158:
7159: IF p_lot_number IS NOT NULL
7160: THEN
7161: UPDATE mtl_transaction_lots_temp
7162: SET transaction_quantity = transaction_quantity - 1
7163: , primary_quantity = primary_quantity - 1
7164: WHERE transaction_temp_id = l_parent_line_id
7165: AND lot_number = p_lot_number;