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_TASK_DISPATCH_PUT_AWAY dependencies on MTL_LOT_NUMBERS

Line 2759: , mtl_lot_numbers mln

2755: , mln.n_attribute10
2756: , mln.vendor_id
2757: , mln.territory_code
2758: FROM mtl_transaction_lots_temp mtlt
2759: , mtl_lot_numbers mln
2760: WHERE mtlt.transaction_temp_id = p_orig_temp_id
2761: AND mln.lot_number = mtlt.lot_number
2762: AND mln.inventory_item_id = p_item_id
2763: AND mln.organization_id = p_organization_id);

Line 2956: FROM mtl_lot_numbers

2952: SELECT expiration_date
2953: , status_id
2954: INTO l_expiration_date
2955: , l_lot_status_id
2956: FROM mtl_lot_numbers
2957: WHERE lot_number = p_lot_number
2958: AND inventory_item_id = p_item_id
2959: AND organization_id = p_org_id;
2960:

Line 3606: l_mol_lot_number mtl_lot_numbers.lot_number%TYPE;

3602: WHERE msni.product_code = 'RCV'
3603: AND msni.product_transaction_id = v_prod_txn_id;
3604:
3605: l_parent_txn_id NUMBER;
3606: l_mol_lot_number mtl_lot_numbers.lot_number%TYPE;
3607: l_result BOOLEAN := TRUE;
3608: l_serial_rec msn_attribute_rec_tp;
3609: l_operation_plan_id NUMBER;
3610: l_ser_mismatch_count NUMBER;