DBA Data[Home] [Help]

APPS.WMS_WIP_INTEGRATION dependencies on MTL_GEN_OBJECT_ID_S

Line 1516: select mtl_gen_object_id_s.nextval into l_object_id from dual;

1512: where serial_number = p_serial_number
1513: and inventory_item_id = l_item_id;
1514:
1515: if( l_object_id is null ) then
1516: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1517: end if;
1518:
1519: UPDATE mtl_serial_numbers
1520: SET

Line 1645: select mtl_gen_object_id_s.nextval into l_object_id from dual;

1641:
1642: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643:
1644: -- Lot number does not exist
1645: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1646:
1647: INSERT INTO mtl_lot_numbers
1648: (INVENTORY_ITEM_ID
1649: ,ORGANIZATION_ID