APPS.WMS_UT_PKG dependencies on MTL_LOT_NUMBERS

Line 521: lotrec mtl_lot_numbers%ROWTYPE;

517: IS
518: -- ,,,,_{,,,,,,
519:
520: moqdrec mtl_onhand_quantities_detail%ROWTYPE;
521: lotrec mtl_lot_numbers%ROWTYPE;
522: serrec mtl_serial_numbers%ROWTYPE;
523:
524: l_last_item VARCHAR2(30);
525: l_item VARCHAR2(30);}

Line 555: from mtl_lot_numbers

551: and rownum = 1;
552:
553: select *
554: into lotrec
555: from mtl_lot_numbers
556: where creation_date > sysdate - 800
557: and rownum = 1;
558:
559: FOR i in 1..l_moqd_lst.count LOOP

Line 677: insert into mtl_lot_numbers(

673:
674: lotrec.lot_number := moqdrec.lot_number;
675: lotrec.inventory_item_id := l_item_id;
676: lotrec.organization_id := p_org_id;
677: insert into mtl_lot_numbers(
678: INVENTORY_ITEM_ID,
679: ORGANIZATION_ID,
680: LOT_NUMBER,
681: LAST_UPDATE_DATE,

Line 2550: UPDATE mtl_lot_numbers

2546: FOR l_param_indx in l_start..p_params.count LOOP
2547: l_obj := p_params(l_param_indx);
2548: IF l_obj_type = 'LOT' THEN
2549: print_debug('Setting status of LOT ' || l_obj || ' to ' || p_params(3));
2550: UPDATE mtl_lot_numbers
2551: SET status_id = l_status_id
2552: WHERE organization_id = p_org_id
2553: AND lot_number = l_obj
2554: AND inventory_item_id = l_item_id;

Line 2677: DELETE FROM mtl_lot_numbers

2673: DELETE FROM mtl_serial_numbers
2674: WHERE current_organization_id = p_org_id
2675: AND inventory_item_id = l_item_id;
2676:
2677: DELETE FROM mtl_lot_numbers
2678: WHERE organization_id = p_org_id
2679: AND inventory_item_id = l_item_id;
2680:
2681: DELETE FROM mtl_onhand_quantities_detail