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 2963: , mtl_lot_numbers mln

2959: , mln.attribute13
2960: , mln.attribute14
2961: , mln.attribute15
2962: FROM mtl_transaction_lots_temp mtlt
2963: , mtl_lot_numbers mln
2964: WHERE mtlt.transaction_temp_id = p_orig_temp_id
2965: AND mln.lot_number = mtlt.lot_number
2966: AND mln.inventory_item_id = p_item_id
2967: AND mln.organization_id = p_organization_id);

Line 3160: FROM mtl_lot_numbers

3156: SELECT expiration_date
3157: , status_id
3158: INTO l_expiration_date
3159: , l_lot_status_id
3160: FROM mtl_lot_numbers
3161: WHERE lot_number = p_lot_number
3162: AND inventory_item_id = p_item_id
3163: AND organization_id = p_org_id;
3164:

Line 3810: l_mol_lot_number mtl_lot_numbers.lot_number%TYPE;

3806: WHERE msni.product_code = 'RCV'
3807: AND msni.product_transaction_id = v_prod_txn_id;
3808:
3809: l_parent_txn_id NUMBER;
3810: l_mol_lot_number mtl_lot_numbers.lot_number%TYPE;
3811: l_result BOOLEAN := TRUE;
3812: l_serial_rec msn_attribute_rec_tp;
3813: l_operation_plan_id NUMBER;
3814: l_ser_mismatch_count NUMBER;