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 632: from mtl_material_transactions_temp

628: INTO l_loaded
629: FROM dual
630: WHERE exists
631: ( SELECT 1
632: from mtl_material_transactions_temp
633: where transaction_header_id
634: =(SELECT transaction_header_id
635: from mtl_material_transactions_temp
636: WHERE transaction_temp_id=p_temp_id)

Line 635: from mtl_material_transactions_temp

631: ( SELECT 1
632: from mtl_material_transactions_temp
633: where transaction_header_id
634: =(SELECT transaction_header_id
635: from mtl_material_transactions_temp
636: WHERE transaction_temp_id=p_temp_id)
637: AND (transfer_lpn_id=p_lpn OR content_lpn_id=p_lpn)
638: AND cost_group_id = p_cost_group_id);
639:

Line 795: FROM mtl_material_transactions_temp mmtt

791:
792:
793: SELECT mmtt.transfer_subinventory
794: INTO l_xfr_sub_code
795: FROM mtl_material_transactions_temp mmtt
796: WHERE mmtt.transaction_temp_id = p_temp_id;
797:
798:
799: -- Check to see if the item is in the LPN

Line 903: from mtl_material_transactions_temp

899:
900: BEGIN
901: select allocated_lpn_id
902: into l_allocated_lpn_id
903: from mtl_material_transactions_temp
904: where transaction_temp_id = p_temp_id;
905: EXCEPTION
906: WHEN no_data_found then
907: IF (l_debug = 1) THEN

Line 1537: FROM mtl_material_transactions_temp

1533: transaction_uom
1534: INTO
1535: l_mmtt_qty,
1536: l_txn_uom
1537: FROM mtl_material_transactions_temp
1538: WHERE transaction_temp_id = p_temp_id;
1539:
1540:
1541: -- If item is lot controlled then validate the lots

Line 2647: FROM mtl_material_transactions_temp mmtt

2643:
2644: --used to xfer records into WDTH
2645: CURSOR mmtt_csr IS
2646: SELECT transaction_temp_id, organization_id, transfer_lpn_id, content_lpn_id
2647: FROM mtl_material_transactions_temp mmtt
2648: WHERE mmtt.transaction_header_id = l_txn_hdr_id;
2649:
2650:
2651: --used to update the account period in mmtt

Line 2777: FROM mtl_material_transactions_temp

2773: l_last_updated_by,
2774: l_transaction_uom,
2775: l_tran_type_id,
2776: l_cost_group_id
2777: FROM mtl_material_transactions_temp
2778: WHERE transaction_temp_id = l_txn_temp_id;
2779:
2780: --Validate the passed quantity
2781: IF l_rec.transaction_quantity IS NOT NULL THEN --chances are that didn't choose suggestion

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

3171: INTO l_per_res_id
3172: , l_wms_task_type
3173: , l_std_op_id
3174: , l_operation_plan_id
3175: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
3176: WHERE t.transaction_temp_id = l_rec.task_id
3177: AND t.standard_operation_id = bsor.standard_operation_id
3178: AND bsor.resource_id = bremp.resource_id
3179: AND bremp.resource_type = 2

Line 3292: UPDATE mtl_material_transactions_temp

3288: --wdr.lpn_id, so no need to check for it being null here
3289:
3290: IF l_lpn_match=1 THEN --and no qty_disc
3291:
3292: UPDATE mtl_material_transactions_temp
3293: SET content_lpn_id = l_rec.lpn_id,
3294: transfer_lpn_id = l_rec.xfer_lpn_id
3295: WHERE transaction_temp_id = l_txn_temp_id
3296: AND organization_id= l_rec.organization_id;

Line 3331: UPDATE mtl_material_transactions_temp

3327: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3328: GOTO continue_loop;
3329:
3330: else
3331: UPDATE mtl_material_transactions_temp
3332: SET lpn_id = l_rec.lpn_id,
3333: transfer_lpn_id = l_rec.xfer_lpn_id
3334: WHERE transaction_temp_id = l_txn_temp_id
3335: AND organization_id= l_rec.organization_id;

Line 3354: UPDATE mtl_material_transactions_temp

3350: l_any_row_failed := TRUE;
3351: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3352: GOTO continue_loop;
3353: else
3354: UPDATE mtl_material_transactions_temp
3355: SET lpn_id = l_rec.lpn_id,
3356: transfer_lpn_id = l_rec.xfer_lpn_id
3357: WHERE transaction_temp_id = l_txn_temp_id
3358: AND organization_id= l_rec.organization_id;

Line 3367: UPDATE mtl_material_transactions_temp

3363: ELSE--PICKED LOOSE
3364: IF (l_debug = 1) THEN
3365: trace('user has picked loose');
3366: END IF;
3367: UPDATE mtl_material_transactions_temp
3368: SET transfer_lpn_id = l_rec.xfer_lpn_id
3369: WHERE transaction_temp_id = l_txn_temp_id
3370: AND organization_id= l_rec.organization_id;
3371:

Line 3424: FROM mtl_material_transactions_temp mmtt

3420: --getting some info.
3421: BEGIN
3422: SELECT COUNT(*)
3423: INTO l_mmtt_count
3424: FROM mtl_material_transactions_temp mmtt
3425: WHERE mmtt.transaction_temp_id <> l_rec.task_id
3426: AND mmtt.move_order_line_id = l_move_order_line_id;
3427: EXCEPTION
3428: WHEN no_data_found THEN

Line 3446: DELETE FROM mtl_material_transactions_temp

3442: IF l_mmtt_count > 0 THEN -- l_mmtt_count > 0
3443: IF (l_debug = 1) THEN
3444: trace('Other MMTT lines exist too. Delete MMTT and UPDATE move ORDER line');
3445: END IF;
3446: DELETE FROM mtl_material_transactions_temp
3447: WHERE transaction_temp_id = l_txn_temp_id;
3448:
3449: IF l_lot_code > 1 THEN
3450:

Line 3522: DELETE FROM mtl_material_transactions_temp

3518: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3519: GOTO continue_loop;
3520: END IF;
3521:
3522: DELETE FROM mtl_material_transactions_temp
3523: WHERE transaction_temp_id = l_txn_temp_id;
3524:
3525: IF l_lot_code > 1 THEN
3526:

Line 3707: UPDATE mtl_material_transactions_temp

3703: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3704: GOTO continue_loop;
3705:
3706: ELSE-- taking from pickLPN to XferLPN
3707: UPDATE mtl_material_transactions_temp
3708: SET lpn_id = l_rec.lpn_id,
3709: transfer_lpn_id = l_rec.xfer_lpn_id
3710: WHERE transaction_temp_id = l_txn_temp_id
3711: AND organization_id= l_rec.organization_id;

Line 3715: UPDATE mtl_material_transactions_temp

3711: AND organization_id= l_rec.organization_id;
3712: end if;
3713: ELSE --means no qty discrepancy
3714:
3715: UPDATE mtl_material_transactions_temp
3716: SET content_lpn_id = l_rec.lpn_id,
3717: transfer_lpn_id = l_rec.xfer_lpn_id
3718: WHERE transaction_temp_id = l_txn_temp_id
3719: AND organization_id= l_rec.organization_id;

Line 3749: UPDATE mtl_material_transactions_temp

3745: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3746: GOTO continue_loop;
3747:
3748: else-- taking from pickLPN to XferLPN
3749: UPDATE mtl_material_transactions_temp
3750: SET lpn_id = l_rec.lpn_id,
3751: transfer_lpn_id = l_rec.xfer_lpn_id
3752: WHERE transaction_temp_id = l_txn_temp_id
3753: AND organization_id= l_rec.organization_id;

Line 3760: UPDATE mtl_material_transactions_temp

3756:
3757: ELSIF l_lpn_match = 3 THEN--already means qty_disc
3758: if l_rec.transaction_quantity = l_lpn_qty_pickable then
3759:
3760: UPDATE mtl_material_transactions_temp
3761: SET content_lpn_id = l_rec.lpn_id,
3762: transfer_lpn_id = l_rec.xfer_lpn_id
3763: WHERE transaction_temp_id = l_txn_temp_id
3764: AND organization_id= l_rec.organization_id;

Line 3780: UPDATE mtl_material_transactions_temp

3776: l_any_row_failed := TRUE;
3777: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3778: GOTO continue_loop;
3779: ELSE
3780: UPDATE mtl_material_transactions_temp
3781: SET lpn_id = l_rec.lpn_id,
3782: transfer_lpn_id = l_rec.xfer_lpn_id
3783: WHERE transaction_temp_id = l_txn_temp_id
3784: AND organization_id= l_rec.organization_id;

Line 3815: UPDATE mtl_material_transactions_temp

3811: l_any_row_failed := TRUE;
3812: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3813: GOTO continue_loop;
3814: else
3815: UPDATE mtl_material_transactions_temp
3816: SET lpn_id = l_rec.lpn_id,
3817: transfer_lpn_id = l_rec.xfer_lpn_id
3818: WHERE transaction_temp_id = l_txn_temp_id
3819: AND organization_id= l_rec.organization_id;

Line 3828: UPDATE mtl_material_transactions_temp

3824: ELSE-- Picked Loose
3825: IF (l_debug = 1) THEN
3826: trace('User has picked loose');
3827: END IF;
3828: UPDATE mtl_material_transactions_temp
3829: SET transfer_lpn_id = l_rec.xfer_lpn_id
3830: WHERE transaction_temp_id = l_txn_temp_id
3831: AND organization_id= l_rec.organization_id;
3832:

Line 3898: UPDATE mtl_material_transactions_temp

3894: IF (l_debug = 1) THEN
3895: trace('Updating MMTT for qty/sub/loc disc');
3896: END IF;
3897:
3898: UPDATE mtl_material_transactions_temp
3899: SET transfer_subinventory = ll_xfer_sub_code
3900: , transfer_to_location = ll_xfer_loc_id
3901: , primary_quantity = ll_pr_qty
3902: , transaction_quantity = ll_mmtt_txn_qty

Line 4051: UPDATE mtl_material_transactions_temp

4047: IF (l_debug = 1) THEN
4048: trace('Updating Headr and txn_status of the Drop record');
4049: END IF;
4050:
4051: UPDATE mtl_material_transactions_temp
4052: SET transaction_date = sysdate
4053: ,transaction_status = 3
4054: ,transaction_header_id = l_txn_hdr_id
4055: WHERE transaction_temp_id = l_txn_temp_id

Line 4204: UPDATE mtl_material_transactions_temp

4200: IF l_period_id <> -1 THEN
4201: IF (l_debug = 1) THEN
4202: trace('Need to update the account period in MMTT');
4203: END IF;
4204: UPDATE mtl_material_transactions_temp
4205: SET acct_period_id = l_period_id
4206: WHERE transaction_temp_id = l_open_period_check.task_id
4207: AND organization_id = l_open_period_check.organization_id;
4208: ELSE

Line 4242: UPDATE mtl_material_transactions_temp mmtt

4238:
4239: -- Modified for bug 7254269 start
4240: IF (l_mmtt_csr.content_lpn_id = l_mmtt_csr.transfer_lpn_id) THEN
4241: -- We are transferring the entire lpn
4242: UPDATE mtl_material_transactions_temp mmtt
4243: set transfer_lpn_id = NULL , lpn_id = NULL
4244: WHERE mmtt.transaction_temp_id = l_mmtt_csr.transaction_temp_id;
4245: END IF;
4246: -- Modified for bug 7254269 end