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_DEVICE_CONFIRMATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 398: INSERT INTO mtl_material_transactions_temp

394: SELECT mtl_material_transactions_s.nextval
395: INTO l_new_txn_temp_id FROM dual ;
396:
397:
398: INSERT INTO mtl_material_transactions_temp
399: ( TRANSACTION_HEADER_ID
400: ,TRANSACTION_TEMP_ID
401: ,SOURCE_CODE
402: ,SOURCE_LINE_ID

Line 865: FROM mtl_material_transactions_temp

861: ,INTRANSIT_ACCOUNT
862: ,FOB_POINT
863: ,MOVE_ORDER_HEADER_ID
864: ,SERIAL_ALLOCATED_FLAG
865: FROM mtl_material_transactions_temp
866: WHERE transaction_temp_id = p_txn_temp_id);
867: IF SQL%NOTFOUND THEN
868: trace (' p_txn_temp_id: NOT found : ' || p_txn_temp_id);
869: fnd_message.set_name('WMS', 'WMS_INSERT_ALLOCATION');

Line 1151: from mtl_material_transactions_temp

1147: INTO l_loaded
1148: FROM dual
1149: WHERE exists
1150: ( SELECT 1
1151: from mtl_material_transactions_temp
1152: where transaction_header_id
1153: =(SELECT transaction_header_id
1154: from mtl_material_transactions_temp
1155: WHERE transaction_temp_id=p_temp_id)

Line 1154: from mtl_material_transactions_temp

1150: ( SELECT 1
1151: from mtl_material_transactions_temp
1152: where transaction_header_id
1153: =(SELECT transaction_header_id
1154: from mtl_material_transactions_temp
1155: WHERE transaction_temp_id=p_temp_id)
1156: AND (transfer_lpn_id=p_lpn OR content_lpn_id=p_lpn)
1157: AND cost_group_id = p_cost_group_id);
1158:

Line 1315: FROM mtl_material_transactions_temp mmtt

1311:
1312:
1313: SELECT mmtt.transfer_subinventory
1314: INTO l_xfr_sub_code
1315: FROM mtl_material_transactions_temp mmtt
1316: WHERE mmtt.transaction_temp_id = p_temp_id;
1317:
1318:
1319: -- Check to see if the item is in the LPN

Line 1423: from mtl_material_transactions_temp

1419:
1420: BEGIN
1421: select allocated_lpn_id
1422: into l_allocated_lpn_id
1423: from mtl_material_transactions_temp
1424: where transaction_temp_id = p_temp_id;
1425: EXCEPTION
1426: WHEN no_data_found then
1427: IF (l_debug = 1) THEN

Line 2057: FROM mtl_material_transactions_temp

2053: transaction_uom
2054: INTO
2055: l_mmtt_qty,
2056: l_txn_uom
2057: FROM mtl_material_transactions_temp
2058: WHERE transaction_temp_id = p_temp_id;
2059:
2060:
2061: -- If item is lot controlled then validate the lots

Line 3173: FROM mtl_material_transactions_temp mmtt

3169:
3170: --used to xfer records into WDTH
3171: CURSOR mmtt_csr IS
3172: SELECT transaction_temp_id, organization_id, transfer_lpn_id, content_lpn_id
3173: FROM mtl_material_transactions_temp mmtt
3174: WHERE mmtt.transaction_header_id = l_txn_hdr_id;
3175:
3176:
3177: --used to update the account period in mmtt

Line 3321: FROM mtl_material_transactions_temp

3317: l_last_updated_by,
3318: l_transaction_uom,
3319: l_tran_type_id,
3320: l_cost_group_id
3321: FROM mtl_material_transactions_temp
3322: WHERE transaction_temp_id = l_txn_temp_id;
3323:
3324: --Validate the passed quantity
3325: IF l_rec.transaction_quantity IS NOT NULL THEN --chances are that didn't choose suggestion

Line 3720: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp

3716: INTO l_per_res_id
3717: , l_wms_task_type
3718: , l_std_op_id
3719: , l_operation_plan_id
3720: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
3721: WHERE t.transaction_temp_id = l_rec.task_id
3722: AND t.standard_operation_id = bsor.standard_operation_id
3723: AND bsor.resource_id = bremp.resource_id
3724: AND bremp.resource_type = 2

Line 3891: UPDATE mtl_material_transactions_temp

3887: --wdr.lpn_id, so no need to check for it being null here
3888:
3889: IF l_lpn_match=1 THEN --and no qty_disc
3890:
3891: UPDATE mtl_material_transactions_temp
3892: SET content_lpn_id = l_rec.lpn_id,
3893: transfer_lpn_id = l_rec.xfer_lpn_id
3894: WHERE transaction_temp_id = l_txn_temp_id
3895: AND organization_id= l_rec.organization_id;

Line 3930: UPDATE mtl_material_transactions_temp

3926: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3927: GOTO continue_loop;
3928:
3929: else
3930: UPDATE mtl_material_transactions_temp
3931: SET lpn_id = l_rec.lpn_id,
3932: transfer_lpn_id = l_rec.xfer_lpn_id
3933: WHERE transaction_temp_id = l_txn_temp_id
3934: AND organization_id= l_rec.organization_id;

Line 3953: UPDATE mtl_material_transactions_temp

3949: l_any_row_failed := TRUE;
3950: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3951: GOTO continue_loop;
3952: else
3953: UPDATE mtl_material_transactions_temp
3954: SET lpn_id = l_rec.lpn_id,
3955: transfer_lpn_id = l_rec.xfer_lpn_id
3956: WHERE transaction_temp_id = l_txn_temp_id
3957: AND organization_id= l_rec.organization_id;

Line 3966: UPDATE mtl_material_transactions_temp

3962: ELSE--PICKED LOOSE
3963: IF (l_debug = 1) THEN
3964: trace('user has picked loose');
3965: END IF;
3966: UPDATE mtl_material_transactions_temp
3967: SET transfer_lpn_id = l_rec.xfer_lpn_id
3968: WHERE transaction_temp_id = l_txn_temp_id
3969: AND organization_id= l_rec.organization_id;
3970:

Line 4023: FROM mtl_material_transactions_temp mmtt

4019: --getting some info.
4020: BEGIN
4021: SELECT COUNT(*)
4022: INTO l_mmtt_count
4023: FROM mtl_material_transactions_temp mmtt
4024: WHERE mmtt.transaction_temp_id <> l_rec.task_id
4025: AND mmtt.move_order_line_id = l_move_order_line_id;
4026: EXCEPTION
4027: WHEN no_data_found THEN

Line 4045: DELETE FROM mtl_material_transactions_temp

4041: IF l_mmtt_count > 0 THEN -- l_mmtt_count > 0
4042: IF (l_debug = 1) THEN
4043: trace('Other MMTT lines exist too. Delete MMTT and UPDATE move ORDER line');
4044: END IF;
4045: DELETE FROM mtl_material_transactions_temp
4046: WHERE transaction_temp_id = l_txn_temp_id;
4047:
4048: IF l_lot_code > 1 THEN
4049:

Line 4128: DELETE FROM mtl_material_transactions_temp

4124: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4125: GOTO continue_loop;
4126: END IF;
4127:
4128: DELETE FROM mtl_material_transactions_temp
4129: WHERE transaction_temp_id = l_txn_temp_id;
4130:
4131: IF l_lot_code > 1 THEN
4132:

Line 4327: UPDATE mtl_material_transactions_temp

4323: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4324: GOTO continue_loop;
4325:
4326: ELSE-- taking from pickLPN to XferLPN
4327: UPDATE mtl_material_transactions_temp
4328: SET lpn_id = l_rec.lpn_id,
4329: transfer_lpn_id = l_rec.xfer_lpn_id
4330: WHERE transaction_temp_id = l_txn_temp_id
4331: AND organization_id= l_rec.organization_id;

Line 4335: UPDATE mtl_material_transactions_temp

4331: AND organization_id= l_rec.organization_id;
4332: end if;
4333: ELSE --means no qty discrepancy
4334:
4335: UPDATE mtl_material_transactions_temp
4336: SET content_lpn_id = l_rec.lpn_id,
4337: transfer_lpn_id = l_rec.xfer_lpn_id
4338: WHERE transaction_temp_id = l_txn_temp_id
4339: AND organization_id= l_rec.organization_id;

Line 4369: UPDATE mtl_material_transactions_temp

4365: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4366: GOTO continue_loop;
4367:
4368: else-- taking from pickLPN to XferLPN
4369: UPDATE mtl_material_transactions_temp
4370: SET lpn_id = l_rec.lpn_id,
4371: transfer_lpn_id = l_rec.xfer_lpn_id
4372: WHERE transaction_temp_id = l_txn_temp_id
4373: AND organization_id= l_rec.organization_id;

Line 4380: UPDATE mtl_material_transactions_temp

4376:
4377: ELSIF l_lpn_match = 3 THEN--already means qty_disc
4378: if l_rec.transaction_quantity = l_lpn_qty_pickable then
4379:
4380: UPDATE mtl_material_transactions_temp
4381: SET content_lpn_id = l_rec.lpn_id,
4382: transfer_lpn_id = l_rec.xfer_lpn_id
4383: WHERE transaction_temp_id = l_txn_temp_id
4384: AND organization_id= l_rec.organization_id;

Line 4400: UPDATE mtl_material_transactions_temp

4396: l_any_row_failed := TRUE;
4397: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4398: GOTO continue_loop;
4399: ELSE
4400: UPDATE mtl_material_transactions_temp
4401: SET lpn_id = l_rec.lpn_id,
4402: transfer_lpn_id = l_rec.xfer_lpn_id
4403: WHERE transaction_temp_id = l_txn_temp_id
4404: AND organization_id= l_rec.organization_id;

Line 4435: UPDATE mtl_material_transactions_temp

4431: l_any_row_failed := TRUE;
4432: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
4433: GOTO continue_loop;
4434: else
4435: UPDATE mtl_material_transactions_temp
4436: SET lpn_id = l_rec.lpn_id,
4437: transfer_lpn_id = l_rec.xfer_lpn_id
4438: WHERE transaction_temp_id = l_txn_temp_id
4439: AND organization_id= l_rec.organization_id;

Line 4448: UPDATE mtl_material_transactions_temp

4444: ELSE-- Picked Loose
4445: IF (l_debug = 1) THEN
4446: trace('User has picked loose');
4447: END IF;
4448: UPDATE mtl_material_transactions_temp
4449: SET transfer_lpn_id = l_rec.xfer_lpn_id
4450: WHERE transaction_temp_id = l_txn_temp_id
4451: AND organization_id= l_rec.organization_id;
4452:

Line 4535: UPDATE mtl_material_transactions_temp

4531: to_unit => l_secondary_uom,
4532: from_name => null,
4533: to_name => null);
4534:
4535: UPDATE mtl_material_transactions_temp
4536: SET transfer_subinventory = ll_xfer_sub_code
4537: , transfer_to_location = ll_xfer_loc_id
4538: , primary_quantity = ll_pr_qty
4539: , secondary_transaction_quantity = ll_sec_qty

Line 4544: UPDATE mtl_material_transactions_temp

4540: , transaction_quantity = ll_mmtt_txn_qty
4541: WHERE transaction_temp_id = l_txn_temp_id
4542: AND organization_id = l_rec.organization_id;
4543: ELSE
4544: UPDATE mtl_material_transactions_temp
4545: SET transfer_subinventory = ll_xfer_sub_code
4546: , transfer_to_location = ll_xfer_loc_id
4547: , primary_quantity = ll_pr_qty
4548: , transaction_quantity = ll_mmtt_txn_qty

Line 4776: UPDATE mtl_material_transactions_temp

4772: IF (l_debug = 1) THEN
4773: trace('Updating Headr and txn_status of the Drop record');
4774: END IF;
4775:
4776: UPDATE mtl_material_transactions_temp
4777: SET transaction_date = sysdate
4778: ,transaction_status = 3
4779: ,transaction_header_id = l_txn_hdr_id
4780: WHERE transaction_temp_id = l_txn_temp_id

Line 4932: UPDATE mtl_material_transactions_temp

4928: IF l_period_id <> -1 THEN
4929: IF (l_debug = 1) THEN
4930: trace('Need to update the account period in MMTT');
4931: END IF;
4932: UPDATE mtl_material_transactions_temp
4933: SET acct_period_id = l_period_id
4934: WHERE transaction_temp_id = l_open_period_check.task_id
4935: AND organization_id = l_open_period_check.organization_id;
4936: ELSE

Line 4970: UPDATE mtl_material_transactions_temp mmtt

4966:
4967: -- Modified for bug 7254269 start
4968: IF (l_mmtt_csr.content_lpn_id = l_mmtt_csr.transfer_lpn_id) THEN
4969: -- We are transferring the entire lpn
4970: UPDATE mtl_material_transactions_temp mmtt
4971: set transfer_lpn_id = NULL , lpn_id = NULL
4972: WHERE mmtt.transaction_temp_id = l_mmtt_csr.transaction_temp_id;
4973: END IF;
4974: -- Modified for bug 7254269 end